Microsoft
AZ-204 · Question #251
You are creating an app that will use CosmosDB for data storage. The app will process batches of relational data. You need to select an API for the app. Which API should you use?
The correct answer is C. SQL API. For relational data you will need the SQL API Incorrect Answer: A: The MongoDB API is not used for relational data. B: The Table API only supports data in the key/value format D: The Cassandra API only supports OLTP (Online Transactional Processing) and not batch…
Submitted by stefanr· Mar 30, 2026Develop for Azure storage
Question
You are creating an app that will use CosmosDB for data storage. The app will process batches of relational data. You need to select an API for the app. Which API should you use?
Options
- AMongoDB API
- BTable API
- CSQL API
- DCassandra API
How the community answered
(66 responses)- A3% (2)
- B6% (4)
- C77% (51)
- D14% (9)
Explanation
For relational data you will need the SQL API Incorrect Answer: A: The MongoDB API is not used for relational data. B: The Table API only supports data in the key/value format D: The Cassandra API only supports OLTP (Online Transactional Processing) and not batch https://docs.microsoft.com/en-us/azure/cosmos-db/choose-api
Topics
#Cosmos DB#SQL API#relational data#API selection
Community Discussion
No community discussion yet for this question.