Microsoft Azure Data FundamentalsDescribe how to work with non-relational data on AzureEasy
A financial institution is migrating its on-premises document database to Azure. The database stores customer transaction records in JSON format and requires high throughput for both reads and writes, along with flexible schema capabilities. Which Azure Cosmos DB API is the most natural fit for this migration?
- ASQL API
- BTable API
- CCassandra API
- DGremlin API
Show answer & explanationAnswer & explanation
Correct answer: A. SQL API
The Azure Cosmos DB SQL API (Core API) is a document database that natively supports JSON documents and offers flexible schema, high throughput, and low-latency access. This makes it the most natural fit for migrating document databases storing JSON data.
Why the other options are wrong
- B. Table API is a key-value store, not suitable for JSON document storage.
- C. Cassandra API is for wide-column stores, not ideal for JSON document models.
- D. Gremlin API is for graph databases, not document databases.
Azure Cosmos DB SQL API
The native API for Azure Cosmos DB, designed for document databases that store JSON documents and can be queried using a SQL-like language.
- Supports flexible schema for JSON documents.
- Offers high throughput and low-latency access.
- Provides a rich set of SQL query capabilities.
Memory trick: SQL's flexibility for JSON documents.