Microsoft Azure Data FundamentalsDescribe an analytics workload on AzureMedium
A global e-commerce company needs to store product catalog data. This data has a highly flexible schema, varies significantly between product categories, and requires low-latency access for millions of concurrent users worldwide. Which Azure database service is best suited for this scenario?
- AAzure Cosmos DB
- BAzure Database for MySQL
- CAzure Database for PostgreSQL
- DAzure SQL Database
Show answer & explanationAnswer & explanation
Correct answer: A. Azure Cosmos DB
Azure Cosmos DB is a globally distributed, multi-model database service that offers high availability, high throughput, and low-latency access, making it ideal for data with flexible schemas and global scale requirements.
Why the other options are wrong
- B. Azure Database for MySQL is a relational database, similar limitations to SQL Database and PostgreSQL for this scenario.
- C. Azure Database for PostgreSQL is a relational database, not designed for flexible schemas or global distribution with guaranteed low latency inherently.
- D. Azure SQL Database is a relational database with a fixed schema, not suitable for highly flexible schemas.
Azure Cosmos DB
A globally distributed, multi-model database service offering turn-key global distribution, elastic scaling, and guaranteed low latency.
- Supports flexible schemas (NoSQL).
- Provides guaranteed single-digit millisecond latency.
- Offers multiple APIs (SQL, MongoDB, Cassandra, Gremlin, Table).
Memory trick: Cosmos DB holds all data, everywhere, flexible and fast.