🔥 3-day streak
Microsoft Azure Cosmos DB Developer Specialty (DP-420)25 / 104
Question 25 of 104

A logistics company stores shipment documents in a Cosmos DB for NoSQL container. A dashboard runs a frequent query that filters on `WHERE c.warehouseId = @id` and returns results ordered by two fields: `ORDER BY c.status ASC, c.createdDate DESC`. The query currently fails at runtime with an error stating that an ORDER BY query requires a corresponding composite index. Which change to the indexing policy will allow this query to execute?

Reviewed for accuracy · Report an issueNext question