Microsoft Certified: Azure Solutions Architect ExpertDesign data storage solutionsMedium
A global e-commerce company plans to migrate its legacy on-premises order processing database to Azure. The database currently handles millions of transactions daily, requires low-latency reads and writes, and needs to scale globally to accommodate peak shopping seasons. The company also requires strong consistency for all financial transactions. Which Azure data storage solution is most suitable for this scenario?
- AAzure Data Lake Storage Gen2
- BAzure SQL Database
- CAzure Table Storage
- DAzure Cosmos DB (Core SQL API)
Show answer & explanationAnswer & explanation
Correct answer: D. Azure Cosmos DB (Core SQL API)
Azure Cosmos DB (Core SQL API) is designed for globally distributed, multi-model databases with low-latency access and high availability. It offers strong consistency models suitable for financial transactions and can scale elastically to handle millions of operations per second.
Why the other options are wrong
- A. Azure Data Lake Storage Gen2 is optimized for big data analytics workloads, not for low-latency, transactional online processing systems requiring strong consistency.
- B. Azure SQL Database offers strong consistency and relational capabilities but may not provide the same global distribution and elastic scalability as Cosmos DB for this specific workload.
- C. Azure Table Storage is a NoSQL key-value store optimized for massive scale but lacks the rich querying and strong consistency features required for complex financial transactions.
Azure Cosmos DB (Core SQL API)
A globally distributed, multi-model database service that offers turn-key global distribution, elastic scaling of throughput and storage, and guaranteed low-latency access.
- Supports various APIs including SQL, MongoDB, Cassandra, Gremlin, and Table.
- Offers multiple consistency models (strong, bounded staleness, session, consistent prefix, eventual).
- Ideal for high-throughput, low-latency applications requiring global reach.
Memory trick: Cosmos is the core for global commerce, fast and consistent.