nerdexam
Microsoft

DP-420 · Question #31

You have the following query. You need to recommend a composite index strategy that will minimize the request units (RUs) consumed by the query. What should you recommend?

Sign in or unlock DP-420 to reveal the answer and full explanation for question #31. The question stem and answer options stay visible for context.

Optimize an Azure Cosmos DB solution

Question

You have the following query. You need to recommend a composite index strategy that will minimize the request units (RUs) consumed by the query. What should you recommend?

Exhibit

DP-420 question #31 exhibit

Options

  • Aa composite index for (sensor ASC, value ASC) and a composite index for (sensor ASC,
  • Ba composite index for (sensor ASC, value ASC, timestamp ASC) and a composite index for
  • Ca composite index for (value ASC, sensor ASC) and a composite index for (timestamp ASC,
  • Da composite index for (sensor ASC, value ASC, timestamp ASC)

Unlock DP-420 to see the answer

You've previewed enough free DP-420 questions. Unlock DP-420 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Composite Indexes#Query Optimization#Request Units#Azure Cosmos DB Performance
Full DP-420 Practice