MENU
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?
Suggested Answer: C
Get Premium DP-420 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
12 comments · newest first
KA
Kaitlyn
5 days ago
Wait, does changing the order really not affect the result set?
RO
Rodrigo
10 days ago
I disagree, B seems more efficient to me.
YV
Yvette
15 days ago
I think option A is the best choice for index optimization.
SO
Solange
20 days ago
D is definitely not the right answer, too many DESC clauses!
FL
Floyd
26 days ago
C looks good, but I’m not sure it’s optimal.
MA
Man
1 month ago
Wait, does changing the order really not affect the result set?
JE
Jesus
1 month ago
I disagree, B seems more efficient to me.
DO
Dorothy
1 month ago
I think option A is the best choice for index optimization.
LE
Lelia
2 months ago
I vaguely recall that using DESC for c.bikeParts could help with performance, but I’m not entirely confident about the order with c._ts.
AL
Alpha
2 months ago
I’m a bit confused about whether to prioritize c._ts or c.bikeParts. I thought c._ts should come first since it’s a timestamp, but I could be wrong.
DA
Dalene
2 months ago
I think we practiced a similar question where we had to optimize a query for performance. I feel like using c.bikeParts first might be the right choice.
BL
Blythe
2 months ago
I remember we discussed how the order of columns in the ORDER BY clause can affect index usage, but I’m not sure which combination is best here.