Microsoft Certified: Azure Developer Associate (AZ-204)Develop for Azure storageMedium
A developer needs to store unstructured sensor data (JSON format) from IoT devices into Azure. The data arrives at extremely high volume and velocity, and queries will primarily involve filtering and aggregating data based on timestamps and device IDs. The solution must support rapid ingestion and flexible schema. Which Azure storage service is best suited for this scenario?
- AAzure Cosmos DB
- BAzure Table Storage
- CAzure SQL Database
- DAzure Blob Storage
Show answer & explanationAnswer & explanation
Correct answer: A. Azure Cosmos DB
Azure Cosmos DB is a globally distributed, multi-model database service that is excellent for high-volume, high-velocity data ingestion like IoT. Its schema-agnostic nature (for NoSQL APIs) and strong indexing capabilities support flexible schema and efficient filtering/aggregation of JSON data.
Why the other options are wrong
- B. Azure Table Storage is for structured NoSQL data but lacks the advanced indexing and query capabilities of Cosmos DB for complex JSON structures.
- C. Azure SQL Database is a relational database and is not ideal for unstructured/semi-structured, high-volume IoT data due to schema rigidity and potential scaling limitations.
- D. Azure Blob Storage is for storing large binary objects, not optimized for querying structured/semi-structured data within the blob itself.
Cosmos DB for IoT
Azure Cosmos DB is well-suited for IoT solutions due to its ability to handle high-volume, high-velocity data ingestion, flexible schema, and low-latency access.
- Scales horizontally for high throughput.
- Schema-agnostic (NoSQL APIs).
- Low-latency reads and writes.
- Supports geospatial, time-series, and other complex queries.
Memory trick: Cosmos DB is the 'Cosmic' solution for IoT's vast data.