What should you do?

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?
A . Configure the report to query orders by using a SQL query.
B. Configure the report to query a new aggregate container. Populate the aggregates by using the change feed.
C. Configure the report to query orders by using a SQL query through a dedicated gateway.
D. Configure the report to query a new aggregate container. Populate the aggregates by using SQL queries that run daily.

View Answer

Answer: D

Explanation:

You can facilitate aggregate data by using Change Feed and Azure Functions, and then use it for reporting.

Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/change-feed