Microsoft Certified: Azure Developer Associate (AZ-204)Develop for Azure storageMedium
A company is developing a new application that processes high volumes of sensor data from IoT devices. The data arrives as JSON documents, needs to be stored with low latency, and requires flexible schema capabilities. The application frequently queries this data using arbitrary attributes. Which Azure Cosmos DB API is most suitable for this scenario?
- ACassandra API
- BMongoDB API
- CGremlin API
- DCore (SQL) API
Show answer & explanationAnswer & explanation
Correct answer: D. Core (SQL) API
The Core (SQL) API in Azure Cosmos DB is ideal for JSON documents, offering flexible schema, low latency, and robust querying capabilities using a SQL-like language for arbitrary attributes, which perfectly suits sensor data processing.
Why the other options are wrong
- A. Cassandra API is for applications built on Apache Cassandra, not native JSON documents with flexible querying.
- B. MongoDB API is for applications built on MongoDB, not native Cosmos DB JSON with SQL-like querying.
- C. Gremlin API is for graph databases, not for storing and querying semi-structured JSON sensor data.
Cosmos DB Core (SQL) API
The Azure Cosmos DB Core (SQL) API is the native API for Cosmos DB, designed for JSON documents. It provides a flexible schema, low latency access, and a powerful SQL-like query language for querying data.
- Native API for Azure Cosmos DB.
- Optimized for JSON documents.
- Supports flexible schema (schemaless).
- Offers a rich SQL query language.
- Guarantees low latency and high availability.
Memory trick: SQL is the core, Mongo for compatibility, Cassandra for speed, Gremlin for graphs, Table for keys.