nerdexam
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)
  • A
    3% (2)
  • B
    6% (4)
  • C
    77% (51)
  • D
    14% (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.

Full AZ-204 Practice