BlackFriday 2024! 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 Exam DP-420 Topic 1 Question 51 Discussion

Actual exam question for Microsoft's DP-420 exam
Question #: 51
Topic #: 1
[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 Lamonica at Sep 16, 2024, 10:16 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel
Queen
1 months ago
I agree, using orderDate as the partition key is a bad idea. It's like trying to fit a million orders into a single shoebox - it just ain't gonna work!
upvoted 0 times
...
Celestina
1 months ago
Yikes, I hope they don't choose orderDate as the partition key. That would be a recipe for disaster, like trying to fit a square peg in a round hole!
upvoted 0 times
Murray
18 days ago
A) You will exceed the maximum number of partition key values.
upvoted 0 times
...
...
Rhea
1 months ago
Not to mention, there will always be a hot partition as new orders come in. That could lead to uneven distribution of the workload.
upvoted 0 times
Dorethea
16 days ago
D) There will always be a hot partition.
upvoted 0 times
...
Broderick
23 days ago
B) Queries will run cross-partition.
upvoted 0 times
...
Rutha
1 months ago
A) You will exceed the maximum number of partition key values.
upvoted 0 times
...
...
Paris
1 months ago
But wouldn't using orderDate as the partition key make queries more efficient for viewing past order history?
upvoted 0 times
...
Yong
1 months ago
Exactly! And with one million orders daily, we'll likely exceed the maximum storage per partition too. This could cause performance problems.
upvoted 0 times
Maricela
21 days ago
Yes, using orderDate as the partition key could lead to exceeding the maximum storage per partition.
upvoted 0 times
...
My
29 days ago
C) You will exceed the maximum storage per partition.
upvoted 0 times
...
Shaunna
1 months ago
A) You will exceed the maximum number of partition key values.
upvoted 0 times
...
...
Kara
2 months ago
I agree with Earleen. Having a hot partition can cause performance issues.
upvoted 0 times
...
Ranee
2 months ago
Using orderDate as the partition key doesn't sound like a good idea. We'll have too many partition key values and that could lead to issues with the maximum number of partitions.
upvoted 0 times
Gerald
1 months ago
C) You will exceed the maximum storage per partition.
upvoted 0 times
...
Cristy
1 months ago
A) You will exceed the maximum number of partition key values.
upvoted 0 times
...
...
Earleen
2 months ago
I think using orderDate as the partition key will lead to a hot partition.
upvoted 0 times
...

Save Cancel