Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-420 Exam - Topic 4 Question 80 Discussion

You have a container in an Azure Cosmos DB for NoSQL account that stores data about orders. The following is a sample of an order document.Documents are up to 2 KB.You plan to receive one million orders daily.Customers will frequently view then past order history.You are the evaluating whether to use orderDate as the partition key.What are two effects of using orderDate as the partition key? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.
B) Queries will run cross-partition. and D) There will always be a hot partition.
A) You will exceed the maximum number of partition key values.
C) You will exceed the maximum storage per partition.

Microsoft DP-420 Exam - Topic 4 Question 80 Discussion

Actual exam question for Microsoft's DP-420 exam
Question #: 80
Topic #: 4
[All DP-420 Questions]

You have a container in an Azure Cosmos DB for NoSQL account that stores data about orders. The following is a sample of an order document.

Documents are up to 2 KB.

You plan to receive one million orders daily.

Customers will frequently view then past order history.

You are the evaluating whether to use orderDate as the partition key.

What are two effects of using orderDate as the partition key? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer: B, D

by Edwin at Jun 30, 2026, 02:16 AM

Limited Time Offer

25%

Off

Get Premium DP-420 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Trinidad
3 days ago
I think using orderDate could lead to a hot partition.
upvoted 0 times
...
Arlene
8 days ago
Wait, how can you exceed partition key values with dates? That’s surprising!
upvoted 0 times
...
Eleonora
13 days ago
D) sounds right, hot partitions can be a real issue.
upvoted 0 times
...
Kimberely
18 days ago
C) seems unlikely, but I’m not sure.
upvoted 0 times
...
Alysa
23 days ago
I think B) is a given if you use orderDate.
upvoted 0 times
...
Karon
29 days ago
A) is definitely a concern with that many orders.
upvoted 0 times
...
Shawnta
1 month ago
I feel like using orderDate could also lead to exceeding the maximum storage per partition, but I need to double-check that detail.
upvoted 0 times
...
Audra
1 month ago
I practiced a similar question where using a date as a partition key caused queries to run cross-partition, which could slow things down.
upvoted 0 times
...
Precious
1 month ago
I think if we use orderDate, we might end up exceeding the maximum number of partition key values, but I'm not entirely sure about that.
upvoted 0 times
...
Laila
2 months ago
I remember that using a date as a partition key could lead to issues with hot partitions, especially if most orders come in on the same day.
upvoted 0 times
...

Save Cancel