Microsoft Certified: Azure Solutions Architect ExpertDesign infrastructure solutionsMedium
A global retail company is deploying a new e-commerce platform that must be highly available and resilient to regional outages. The platform will serve customers worldwide and requires extremely low latency access to product catalogs and customer profiles. Data consistency is eventually consistent. Which Azure database solution should be chosen to meet these requirements?
- AAzure Database for PostgreSQL
- BAzure SQL Database
- CAzure Cosmos DB
- DAzure Database for MySQL
Show answer & explanationAnswer & explanation
Correct answer: C. Azure Cosmos DB
Azure Cosmos DB is a globally distributed, multi-model database service designed for high availability, low latency, and elastic scalability. Its ability to distribute data globally with multiple consistency models, including eventual consistency, makes it ideal for global e-commerce platforms requiring worldwide low-latency access.
Why the other options are wrong
- A. Azure Database for PostgreSQL is a relational database, similar to SQL Database, and not primarily designed for global distribution with eventual consistency at the core.
- B. Azure SQL Database is a relational database, which can be geo-replicated but typically offers stronger consistency models that may impact global write latency.
- D. Azure Database for MySQL is a relational database and shares similar limitations to SQL Database and PostgreSQL for global distribution with low-latency, eventually consistent reads/writes.
Azure Cosmos DB
Azure Cosmos DB is a globally distributed, multi-model database service that offers turn-key global distribution, elastic scale of throughput and storage, and guaranteed low-latency with multiple consistency models.
- Globally distributed, multi-region writes
- Guaranteed low latency (reads and writes)
- Tunable consistency models (e.g., eventual consistency)
Memory trick: Cosmos DB reaches across the globe, giving everyone their data super fast, even if it takes a tiny moment to agree.