DP-200 Azure Data Storage Solutions 2 — Questions and Answers
Question 1: What format does Azure Cosmos DB use to store data in its Core (SQL) API?
- Relational rows and columns
- JSON documents (Correct answer)
- Graph nodes and edges
- Wide-column key-value pairs
Correct answer: JSON documents
Azure Cosmos DB's Core (SQL) API stores data as JSON documents, enabling flexible schema-less data modeling.
Question 2: In Azure Cosmos DB, what does the Request Unit (RU) measure?
- Network bandwidth consumption
- The cost of database operations in terms of CPU, memory, and I/O (Correct answer)
- Disk storage used per document
- Number of concurrent connections
Correct answer: The cost of database operations in terms of CPU, memory, and I/O
Request Units abstract the combined CPU, memory, and I/O resources consumed by a single database operation in Cosmos DB.
Question 3: Which Cosmos DB consistency level provides the strongest consistency guarantees?
- Eventual
- Consistent prefix
- Session
- Strong (Correct answer)
Correct answer: Strong
Strong consistency guarantees that reads always return the most recent committed write, at the cost of higher latency.
Question 4: What is the maximum size of a single document in Azure Cosmos DB?
- 1 MB
- 2 MB (Correct answer)
- 4 MB
- 16 MB
Correct answer: 2 MB
Azure Cosmos DB enforces a maximum document size of 2 MB to ensure consistent performance and efficient indexing.
Question 5: Which Azure Cosmos DB feature automatically distributes data and throughput across multiple partitions?
- Change feed
- Automatic indexing
- Horizontal partitioning (Correct answer)
- Time-to-Live (TTL)
Correct answer: Horizontal partitioning
Horizontal partitioning in Cosmos DB automatically splits data across logical and physical partitions to scale throughput and storage.
Question 6: What Azure Cosmos DB feature can be used to trigger downstream processing whenever data in a container is inserted or updated?
- Stored procedures
- Change feed (Correct answer)
- UDFs
- Triggers
Correct answer: Change feed
The change feed feature in Cosmos DB provides a persistent log of inserts and updates that downstream services can consume for event-driven processing.
DP-200 Azure Data Storage Solutions 2
What format does Azure Cosmos DB use to store data in its Core (SQL) API?