Tag: Azure Cosmos DB APIs

azure, DP-900, Microsoft Certification

Practice Questions: Describe Azure Cosmos DB APIs (DP-900 Exam Prep)

Practice Questions

Question 1

Which API in Azure Cosmos DB uses a SQL-like query language?

A. Gremlin API
B. Cassandra API
C. Core (SQL) API
D. Table API

✅ Answer: C

Explanation:
The Core (SQL) API uses a SQL-like syntax to query JSON documents.

Question 2

Which Azure Cosmos DB API is BEST suited for applications currently using MongoDB?

A. Core (SQL) API
B. MongoDB API
C. Cassandra API
D. Table API

✅ Answer: B

Explanation:
The MongoDB API provides compatibility with MongoDB drivers and queries.

Question 3

Which API should you choose for graph-based data and relationships?

A. Table API
B. Cassandra API
C. Gremlin API
D. MongoDB API

✅ Answer: C

Explanation:
The Gremlin API is designed for graph data models and relationship analysis.

Question 4

Which API in Cosmos DB is most similar to Azure Table Storage?

A. MongoDB API
B. Cassandra API
C. Table API
D. Core (SQL) API

✅ Answer: C

Explanation:
The Table API uses a key-value model similar to Azure Table Storage.

Question 5

Which statement about Azure Cosmos DB APIs is TRUE?

A. You can switch APIs after creating the account
B. Each API uses a different query language and data model
C. All APIs use T-SQL
D. APIs determine storage redundancy

✅ Answer: B

Explanation:
Each API has its own data model and query language.

Question 6

Which API would you choose for a distributed system currently using Apache Cassandra?

A. Core (SQL) API
B. MongoDB API
C. Cassandra API
D. Gremlin API

✅ Answer: C

Explanation:
The Cassandra API supports Cassandra Query Language (CQL) and workloads.

Question 7

Which API is the default and most commonly used in Azure Cosmos DB?

A. Table API
B. Gremlin API
C. Core (SQL) API
D. Cassandra API

✅ Answer: C

Explanation:
The Core (SQL) API is the most commonly used and general-purpose API.

Question 8

Which scenario is BEST suited for the Table API?

A. Complex graph traversal
B. Large-scale relational queries
C. Simple key-value data storage
D. Document-based analytics

✅ Answer: C

Explanation:
The Table API is ideal for simple, scalable key-value storage.

Question 9

What is a key consideration when choosing a Cosmos DB API?

A. The size of the storage account
B. The number of virtual machines
C. The application’s existing data model and query language
D. The type of Azure subscription

✅ Answer: C

Explanation:
API selection depends on existing technologies and data models.

Question 10

Which statement best describes Azure Cosmos DB APIs?

A. Each API uses a different underlying database engine
B. APIs provide different ways to interact with the same service
C. APIs are only used for relational data
D. APIs determine the pricing tier only

✅ Answer: B

Explanation:
All APIs use the same Cosmos DB service but offer different interfaces and models.

✅ Quick Exam Takeaways

✔ Cosmos DB APIs allow different ways to interact with the same service

✔ APIs:

  • Core (SQL) → SQL-like queries (most common)
  • MongoDB → MongoDB compatibility
  • Cassandra → Distributed systems (CQL)
  • Table → Key-value storage
  • Gremlin → Graph data

✔ Key concepts:

  • API choice depends on data model and existing system
  • API selection is permanent after creation

✔ Exam tip:
👉 Match data model → API type

Go to the DP-900 Exam Prep Hub main page.