Microsoft Certified: Azure Developer Associate (AZ-204)Develop for Azure storageMedium
An application is designed to store sensor data from IoT devices. The data is high-volume, time-series, and unstructured JSON documents. The development team needs a NoSQL database that can handle millions of small writes per second, provide flexible schema, and allow for efficient querying of time-series data.
- AAzure SQL Database
- BAzure Cosmos DB for NoSQL (Core) API
- CAzure Table Storage
- DAzure Database for PostgreSQL
Show answer & explanationAnswer & explanation
Correct answer: B. Azure Cosmos DB for NoSQL (Core) API
Azure Cosmos DB for NoSQL (Core) API is a globally distributed, multi-model database service that supports schema-less JSON documents. Its ability to handle high throughput, flexible schema, and robust querying makes it an excellent choice for high-volume, time-series IoT data.
Why the other options are wrong
- A. Azure SQL Database is a relational database, not ideal for unstructured, high-volume JSON documents.
- C. Azure Table Storage is a key-value store for structured data, lacking the flexible schema and rich query capabilities needed for complex JSON documents.
- D. Azure Database for PostgreSQL is a relational database, not suited for unstructured JSON and high-volume NoSQL workloads.
Cosmos DB Core (SQL) API for IoT
Azure Cosmos DB's Core (SQL) API is a NoSQL document database designed for high-performance, globally distributed applications, capable of storing unstructured JSON data with flexible schemas, making it ideal for high-volume IoT telemetry.
- Supports JSON documents with flexible schema.
- Offers high throughput and low-latency access.
- Provides robust SQL-like querying capabilities for JSON.
Memory trick: Cosmos DB Core handles IoT's JSON flow.