What should you recommend?

You need to recommend a data store service that meets the following requirements:

✑ Native SQL API access

✑ Configurable indexes

What should you recommend?
A . Azure Files
B . Azure Blob storage
C . Azure Table storage
D . Azure Cosmos DB

View Answer

Answer: D

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.

Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/sql/how-to-manage-indexing-policy