🔥 3-day streak
Microsoft Azure Cosmos DB Developer Specialty (DP-420)26 / 104
Question 26 of 104
A retail analytics team runs a frequent query against a Cosmos DB container that returns the newest, highest-value orders: SELECT * FROM c WHERE c.status = 'shipped' ORDER BY c.orderDate DESC, c.totalAmount DESC. The query currently fails at runtime with an error indicating the ORDER BY clause cannot be served. The container uses the default indexing policy. What is the most appropriate change to make this multi-property ORDER BY query succeed with minimal RU overhead?
Reviewed for accuracy · Report an issueNext question