Microsoft Azure Data FundamentalsDescribe an analytics workload on AzureMedium
A multinational e-commerce company needs to store product catalog data that has a highly flexible schema and requires low-latency access from globally distributed applications. The data model changes frequently, and different products might have entirely different attributes. Which Azure data storage service is most appropriate for this scenario?
- AAzure Database for MySQL
- BAzure Cosmos DB
- CAzure Data Lake Storage Gen2
- DAzure SQL Database
Show answer & explanationAnswer & explanation
Correct answer: B. Azure Cosmos DB
Azure Cosmos DB is a globally distributed, multi-model database service that provides single-digit millisecond latency at any scale, flexible schema, and support for various NoSQL APIs, making it ideal for dynamic, globally accessed data.
Why the other options are wrong
- A. Azure Database for MySQL is also a relational database, sharing the same limitations as Azure SQL Database for flexible schema requirements.
- C. Azure Data Lake Storage Gen2 is primarily for big data analytics storage, not for low-latency, transactional access from globally distributed applications.
- D. Azure SQL Database is a relational database with a rigid schema, not suitable for 'highly flexible schema' and 'different attributes' per item.
Azure Cosmos DB
A globally distributed, multi-model database service that offers turn-key global distribution, elastic scaling of throughput and storage, and guaranteed single-digit millisecond latency at the 99th percentile.
- Supports multiple APIs (SQL, MongoDB, Cassandra, Gremlin, Table).
- Provides flexible schema for dynamic data models.
- Ideal for web, mobile, gaming, and IoT applications requiring low-latency access worldwide.
Memory trick: Cosmos DB is the universe of flexible, fast data.