Microsoft Certified: Azure Solutions Architect ExpertDesign data storage solutionsHard
A global energy company is developing a new application to manage its supply chain. The application requires a database that can handle highly variable transaction volumes, scale elastically to millions of requests per second, and maintain strong consistency across multiple regions for critical inventory data. The data model is document-based. Which Azure data storage solution is most appropriate?
- AAzure Table Storage
- BAzure Database for MySQL Flexible Server
- CAzure Cosmos DB (MongoDB API)
- DAzure SQL Database Business Critical
Show answer & explanationAnswer & explanation
Correct answer: C. Azure Cosmos DB (MongoDB API)
Azure Cosmos DB (MongoDB API) provides a globally distributed, multi-model database service that supports the MongoDB API, offering elastic scalability, high throughput, low latency, and strong consistency across regions, ideal for a document-based data model with variable transaction volumes and global reach.
Why the other options are wrong
- A. Azure Table Storage is a NoSQL key-value store optimized for high-volume, low-cost storage, but it does not offer the same level of global distribution, strong consistency, or rich query capabilities as Cosmos DB for complex document models.
- B. Azure Database for MySQL Flexible Server is a relational database and does not provide the global distribution, elastic scalability to millions of requests per second, or native document model support required.
- D. Azure SQL Database Business Critical is a relational database offering high performance and availability but lacks the native document model support and elastic scalability to millions of requests per second across regions that Cosmos DB provides.
Azure Cosmos DB (MongoDB API)
A fully managed NoSQL database service that implements the wire protocol for MongoDB, allowing existing MongoDB applications to connect to Azure Cosmos DB as if it were a MongoDB database.
- Provides global distribution and horizontal scaling
- Supports strong consistency across regions
- Compatible with MongoDB drivers and tools
Memory trick: Cosmos DB MongoDB: Global docs, strong consistency, elastic scale.