Exam: DP-900: Microsoft Azure Data Fundamentals 0 Likes
You need to recommend a data store service that meets the following (DP-900)
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
Solution
Correct answer: D. Azure Cosmos DB.
Here's why:
1 - Native SQL API access:
Azure Cosmos DB provides a native SQL API, which allows you to interact with the data using standard SQL-like queries.
This is in contrast to other Azure data store services like Azure Table storage, which have a different query API.
2 - Configurable indexes:
Azure Cosmos DB allows you to configure the indexing policy for your data, enabling you to customize the indexing behavior to suit your application's needs.
This provides more flexibility compared to other Azure data store services, which may have more limited indexing capabilities.
Category: Identify considerations for relational data on Azure