Azure Cosmos DB: The Ideal Choice for Native SQL API Access

D

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.

The best option to meet the given requirements is Azure Cosmos DB.

Here's why:

Azure Cosmos DB is a globally distributed, multi-model database service that supports multiple NoSQL data models including document, graph, key-value, column-family, and more. It offers a native SQL API that supports querying data using SQL syntax, making it an excellent option for applications that require SQL query support.

Azure Cosmos DB also offers configurable indexing. With Cosmos DB, you can configure various indexing policies to optimize your queries and reduce query latency. You can choose from various indexing options like range, hash, and spatial indexes, depending on your data and query requirements.

Now, let's take a look at the other options and why they are not the best fit for the given requirements:

Azure Files is a fully managed cloud file share service that supports SMB (Server Message Block) protocol. It is designed for storing and accessing files in the cloud using standard SMB protocol. Azure Files does not support native SQL API access or configurable indexes, so it is not the best fit for the given requirements.

Azure Blob storage is a fully managed cloud object storage service for unstructured data like images, videos, and documents. It offers REST API access, but not a native SQL API. Azure Blob storage does