You need to recommend a data store service that meets the following requirements: - Native SQL API access - Configurable indexes What should you recommend?

The correct answer is D. Azure Cosmos DB. Azure Cosmos DB comes with native Core (SQL) API support. In Azure Cosmos DB, data is indexed following indexing policies that are defined for each container. The default indexing policy for newly created containers enforces range indexes for any string or number. This policy…

Submitted by anjalisingh· Mar 30, 2026Describe considerations for non-relational data on Azure

Question

You need to recommend a data store service that meets the following requirements: - Native SQL API access - Configurable indexes What should you recommend?

Options

AAzure Files
BAzure Blob storage
CAzure Table storage
DAzure Cosmos DB

How the community answered

(32 responses)

A
3% (1)
B
16% (5)
C
6% (2)
D
75% (24)

Explanation

Azure Cosmos DB comes with native Core (SQL) API support. In Azure Cosmos DB, data is indexed following indexing policies that are defined for each container. The default indexing policy for newly created containers enforces range indexes for any string or number. This policy can be overridden with your own custom indexing policy. https://docs.microsoft.com/en-us/azure/cosmos-db/sql/how-to-manage-indexing-policy

Topics

#Azure Cosmos DB#SQL API#configurable indexes#non-relational storage

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice