The following is a sample of a document in orders.

Microsoft DP-420 Question Answer

The orders container uses customer 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?

Configure the report to query orders by using a SQL query.

Configure the report to query a new aggregate container. Populate the aggregates by using the change feed.

Configure the report to query orders by using a SQL query through a dedicated gateway.

Configure the report to query a new aggregate container. Populate the aggregates by using SQL queries that run daily.

Microsoft DP-420 Summary

Price: $52.5 ~~$149.99~~