Microsoft Azure Data FundamentalsDescribe how to work with non-relational data on AzureHard
A global online streaming service needs to store user watch history, recommendations, and preferences. This data needs to be available with single-digit millisecond latency worldwide and support multiple data models (document, graph). The service anticipates massive, unpredictable spikes in traffic. Which Azure service is designed to meet these requirements?
- AAzure SQL Database
- BAzure Data Lake Storage Gen2
- CAzure Cosmos DB
- DAzure Database for PostgreSQL
Show answer & explanationAnswer & explanation
Correct answer: C. Azure Cosmos DB
Azure Cosmos DB is a globally distributed, multi-model database service that guarantees single-digit millisecond latency, elastic scalability, and supports various APIs including document (SQL, MongoDB) and graph (Gremlin), perfectly aligning with the requirements for global availability, low latency, and varied data models.
Why the other options are wrong
- A. Azure SQL Database is a relational database and does not natively support multi-model data or global distribution with guaranteed low latency.
- B. Azure Data Lake Storage Gen2 is for big data analytics and data warehousing, not low-latency transactional NoSQL operations.
- D. Azure Database for PostgreSQL is a relational database and does not meet the multi-model or global low-latency requirements.
Azure Cosmos DB
Microsoft's globally distributed, multi-model database service for mission-critical applications.
- Guarantees single-digit millisecond latency at the 99th percentile.
- Supports multiple APIs: SQL, MongoDB, Cassandra, Gremlin, Table.
- Offers five well-defined consistency models.
- Provides elastic scalability for throughput and storage worldwide.
Memory trick: Cosmos is 'Cosmic' in scale and speed, covering the 'globe' with 'multiple' ways to interact.