nerdexam
MicrosoftMicrosoft

DP-420 · Question #138

DP-420 Question #138: Real Exam Question with Answer & Explanation

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

Optimize an Azure Cosmos DB solution

Question

The following is a sample of a document in orders. The orders container uses customerId as the partition key. You need to provide a report of the total items ordered per month by item type. The solution must meet the following requirements: - Ensure that the report can run as quickly as possible. - Minimize the consumption of request units (RUs). What should you do?

Options

  • AConfigure the report to query orders by using a SQL query.
  • BConfigure the report to query a new materialized view. Populate the view by using the change
  • CConfigure the report to query orders by using a SQL query through a dedicated gateway.
  • DConfigure the report to query a new materialized view. Populate the view by using SQL queries

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

#Materialized Views#Change Feed#Query Optimization#Cross-partition Queries
Full DP-420 PracticeBrowse All DP-420 Questions