AZ-305 · Question #218
A company needs a datastore created in Azure for an application. Below are the key requirements for the data store. - Ability to store JSON based items - Ability to use SQL like queries on the…
The correct answer is B. Azure CosmosDB. To store JSON-based items, enable SQL-like queries, and ensure low-latency access, Azure Cosmos DB is the ideal datastore choice.
Question
Options
- AAzure BLOB storage
- BAzure CosmosDB
- CAzure HDInsight
- DAzure Redis
How the community answered
(48 responses)- A2% (1)
- B90% (43)
- C6% (3)
- D2% (1)
Why each option
To store JSON-based items, enable SQL-like queries, and ensure low-latency access, Azure Cosmos DB is the ideal datastore choice.
Azure Blob storage is object storage, not a document database, and does not natively support SQL-like querying on JSON item contents.
Azure Cosmos DB is a globally distributed, multi-model database service that natively stores JSON documents, offers a SQL API for querying, and is designed for single-digit millisecond latency access.
Azure HDInsight is a big data analytics service, not a low-latency transactional datastore for individual JSON items with SQL-like queries.
Azure Redis Cache is an in-memory key-value store primarily for caching, not a document database that supports SQL-like queries on JSON items.
Concept tested: Azure Cosmos DB capabilities (JSON, SQL API, low latency)
Source: https://learn.microsoft.com/en-us/azure/cosmos-db/introduction
Community Discussion
No community discussion yet for this question.