Microsoft Azure Data FundamentalsDescribe how to work with non-relational data on AzureMedium
A global manufacturing company needs to store machine telemetry data from thousands of devices. This data needs to be queried quickly for real-time dashboards and predictive maintenance. The data structure is dynamic and can change frequently as new sensors are added. Which Azure non-relational data service is the MOST appropriate for this scenario?
- AAzure Data Lake Storage Gen2
- BAzure Blob Storage
- CAzure Table Storage
- DAzure Cosmos DB (MongoDB API)
Show answer & explanationAnswer & explanation
Correct answer: D. Azure Cosmos DB (MongoDB API)
Azure Cosmos DB with the MongoDB API is ideal for this scenario due to its flexible schema for dynamic data, high throughput for telemetry, and low-latency query capabilities for real-time dashboards. It natively supports document models, which align well with evolving sensor data.
Why the other options are wrong
- A. Azure Data Lake Storage Gen2 is optimized for large-scale analytics and data lakes, not for real-time operational queries on frequently changing data schemas.
- B. Azure Blob Storage is suitable for unstructured binary data, but not optimized for real-time querying of structured or semi-structured telemetry with flexible schemas.
- C. Azure Table Storage offers a key-value store with a flexible schema but lacks the rich querying capabilities and global distribution of Cosmos DB, making it less suitable for complex real-time dashboards.
Azure Cosmos DB (MongoDB API)
Azure Cosmos DB's MongoDB API allows developers to interact with Cosmos DB using MongoDB client drivers and tools, providing a globally distributed, multi-model database service with the flexibility of the MongoDB document model.
- Compatible with existing MongoDB applications and tools.
- Offers flexible schema for diverse and evolving data.
- Provides global distribution and high availability.
- Supports low-latency reads and writes at scale.
Memory trick: Think 'Flexible Scales Global Dashboards' for Cosmos DB's MongoDB API.