Microsoft Azure Data FundamentalsDescribe how to work with non-relational data on AzureMedium
A data engineering team is designing a data ingestion pipeline for real-time telemetry data from millions of IoT devices. The data arrives as JSON documents and needs to be stored in a NoSQL database that offers flexible schema and can handle high throughput with low latency. The team also requires the ability to query this data using a familiar SQL-like language. Which Azure Cosmos DB API is the MOST appropriate choice?
- AAzure Cosmos DB for Gremlin (Graph) API
- BAzure Cosmos DB for Apache Cassandra
- CAzure Cosmos DB for NoSQL (Core) API
- DAzure Cosmos DB for Table
Show answer & explanationAnswer & explanation
Correct answer: C. Azure Cosmos DB for NoSQL (Core) API
Azure Cosmos DB for NoSQL (Core) API is the native API for Cosmos DB, designed for JSON document data. It offers flexible schema, high throughput, low latency, and supports a rich SQL-like query language, making it ideal for storing and querying real-time JSON telemetry data from IoT devices.
Why the other options are wrong
- A. The Gremlin API is for graph databases and is not suitable for a flat stream of JSON documents.
- B. The Cassandra API is for existing Cassandra workloads and uses CQL, not a SQL-like language for JSON documents.
- D. The Table API is a key-value store, suitable for simple schema-less data but less flexible for complex JSON documents or SQL-like querying.
Azure Cosmos DB for NoSQL (Core) API
The native API for Azure Cosmos DB, designed for JSON document data with flexible schema and SQL-like querying.
- Stores data as JSON documents.
- Supports a rich SQL-like query language.
- Offers flexible schema, ideal for evolving data.
- Provides global distribution, high throughput, and low latency.
Memory trick: For JSON documents and SQL queries, think 'Core' (SQL) or 'Mongo' for existing apps.