Question
You have a container named container1 in an Azure Cosmos DB for NoSQL account. The container1 container has 120 GB of data.
A sample of a document in container1 is shown in the exhibit.
The orderId property is used as the partition key.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Explanation
Statement 1 (Yes): The filter is only on orderDate, which is not the partition key. Azure Cosmos DB cannot route the query to one logical partition, so it fans out across all physical partitions of the 120 GB container.
Statement 2 (Yes): customerId is also not the partition key, so the query must check every partition even though it filters on a single value.
Statement 3 (No): The query includes an equality filter on orderId, the partition key, so the gateway or SDK routes it to the single partition that owns that key value. The additional orderDate filter is evaluated inside that partition.
