You have an Azure Cosmos DB for NoSQL account that contains a database named DB1.

Microsoft DP-420 Question Answer

You have an Azure Cosmos DB for NoSQL account that contains a database named DB1. Users run the following query against DB1.

You add an index to the recordset.

You need to change the ORDER by syntax of the query to optimize the use of the index. The solution must NOT change the result set.

Which syntax should you use?

ORDER BY c._ts MSC, c.bikeParts ASC

ORDER BY c._ts ASC, c.bikeParts DESC

ORDER BY c.bikeParts ASC, c._ts ASC

order BY c.bikeParts DESC, c._ts ASC

DP-420 PDF/Engine

Get 75% Discount on All Products, Use Coupon: "ac75sure"