Microsoft Azure Data FundamentalsDescribe an analytics workload on AzureHard
A large e-commerce company needs to store product catalog data. This data has a highly flexible schema, with different products having different attributes. The company also requires low-latency access to this data globally for its various storefronts. Which Azure database service is best suited for these requirements?
- AAzure SQL Database
- BAzure Synapse Analytics dedicated SQL pool
- CAzure Database for PostgreSQL
- DAzure Cosmos DB
Show answer & explanationAnswer & explanation
Correct answer: D. Azure Cosmos DB
Azure Cosmos DB is a globally distributed, multi-model database service that offers turn-key global distribution, guaranteeing low-latency access anywhere in the world. Its flexible schema capabilities (e.g., DocumentDB API for JSON documents) make it ideal for data with varying attributes like product catalogs.
Why the other options are wrong
- A. Azure SQL Database is a relational database with a fixed schema, not suitable for highly flexible data attributes.
- B. Azure Synapse Analytics dedicated SQL pool is a data warehouse for structured analytical data, not an operational database for flexible, low-latency transactional access.
- C. Azure Database for PostgreSQL is also a relational database with a fixed schema, not ideal for varying product attributes.
Azure Cosmos DB
A globally distributed, multi-model database service that offers low-latency access, automatic scaling, and flexible schema capabilities.
- Supports multiple APIs (SQL, MongoDB, Cassandra, Gremlin, Table).
- Turn-key global distribution with guaranteed low latency.
- Ideal for flexible schema data and high availability requirements.
Memory trick: Cosmos is for global data with a flexible inner universe.