Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-420 Exam - Topic 1 Question 82 Discussion

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?Which syntax should you use?
C) ORDER BY c.bikeParts ASC, c._ts ASC
A) ORDER BY c._ts MSC, c.bikeParts ASC
B) ORDER BY c._ts ASC, c.bikeParts DESC
D) order BY c.bikeParts DESC, c._ts ASC

Microsoft DP-420 Exam - Topic 1 Question 82 Discussion

Actual exam question for Microsoft's DP-420 exam
Question #: 82
Topic #: 1
[All DP-420 Questions]

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?

Which syntax should you use?

Show Suggested Answer Hide Answer
Suggested Answer: C

by Heike at Aug 16, 2026, 08:47 AM

Limited Time Offer

25%

Off

Get Premium DP-420 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel

Currently there are no comments in this discussion, be the first to comment!


Save Cancel