A company needs a data store 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 data…

The correct answer is B. Azure CosmosDB. You can use CosmosDB to provide low latency access to data. You can use the SQL API to store JSON based objects. The Microsoft documentation mentions the following: Option A is incorrect since this is used for object level storage. Option C is incorrect since this is used for…

Submitted by haruto_sh· Mar 6, 2026Design data storage solutions

Question

A company needs a data store 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 data store - Ability to provide low latency access to data items Which of the following would you consider as the data store?

Exhibit

Options

AAzure BLOB storage
BAzure CosmosDB
CAzure HDInsight
DAzure Redis

How the community answered

(44 responses)

A
5% (2)
B
77% (34)
C
14% (6)
D
5% (2)

Explanation

You can use CosmosDB to provide low latency access to data. You can use the SQL API to store JSON based objects. The Microsoft documentation mentions the following: Option A is incorrect since this is used for object level storage. Option C is incorrect since this is used for open source analytics. Option D is incorrect since this is used for storing data in a low memory cache. https://docs.microsoft.com/en-us/azure/cosmos-db/how-to-sql-query

Community Discussion

No community discussion yet for this question.

Full AZ-305 Practice