Exam DP-420 All Questions

View all questions & answers for the DP-420 exam

Exam DP-420 topic 3 question 2 discussion

Actual exam question from Microsoft's DP-420

Question #: 2
Topic #: 3

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.

Show Suggested Answer

Suggested Answer: B 🗳️

by grada at July 15, 2022, 3:56 p.m.

Comments

Submit Cancel

grada

Highly Voted 2 years, 7 months ago

Selected Answer: B

After processing items in the change feed, you can build a materialized view and persist aggregated values back in Azure Cosmos DB. If you're using Azure Cosmos DB to build a game, you can, for example, use change feed to implement real-time leaderboards based on scores from completed games. https://docs.microsoft.com/en-us/azure/cosmos-db/sql/change-feed-design-patterns#high-availability

upvoted 10 times

...

YellowSky002

Most Recent 7 months ago

Selected Answer: B

For most scenarios, using the change feed to populate aggregates in Cosmos DB is the more RU-efficient approach. It allows you to process changes incrementally, update aggregates in real-time, and avoid the overhead of full scans. However, consider your specific data volume, change frequency, and aggregate complexity to choose the most appropriate strategy.

upvoted 2 times

...

Blubb1860

1 year, 1 month ago

Selected Answer: B

B is correct, no additional SQL queries necessary

upvoted 1 times

...

comoon

1 year, 5 months ago

Selected Answer: D

The answer is D

upvoted 1 times

...

azuredemo2022three

1 year, 8 months ago

Selected Answer: B

upvoted 2 times

...

BOT_123

2 years ago

Selected Answer: B

B Is Correct

upvoted 2 times

...

TimSss

2 years, 4 months ago

Selected Answer: D

I would go with D, we need to minimize RU, so we run the job daily which should be fine for these types of reports (using monthly data). Using the change feed costs much more RU.

upvoted 4 times

...

remz

2 years, 5 months ago

Selected Answer: B

B Is Correct

upvoted 2 times

...

Gall

2 years, 6 months ago

Selected Answer: D

I would go with D, as we need to reduce RU. An additional container writes costs RU and the change-feed will be updated every time a new item appears.

upvoted 2 times

...