Microsoft
DP-420 · Question #18
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 soluti
Sign in or unlock DP-420 to reveal the answer and full explanation for question #18. 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?
Exhibit
Options
- AConfigure the report to query orders by using a SQL query.
- BConfigure the report to query a new aggregate container. Populate the aggregates by using the
- CConfigure the report to query orders by using a SQL query through a dedicated gateway.
- DConfigure the report to query a new aggregate container. Populate the aggregates by using SQL
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
#Change Feed#Data Aggregation#Performance Optimization#Cost Optimization