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 2 Question 57 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 their past order history.You are the evaluating whether to use order-Date as the partition key.What are two effects of using order-Date as the partition key? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.
C) There will always be a hot partition. and D) Queries will run cross-partition.
A) You will exceed the maximum number of partition key values.
B) You will exceed the maximum storage per partition.

Microsoft DP-420 Exam - Topic 2 Question 57 Discussion

Actual exam question for Microsoft's DP-420 exam
Question #: 57
Topic #: 2
[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 their past order history.

You are the evaluating whether to use order-Date as the partition key.

What are two effects of using order-Date 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: C, D

by Earlean at Jan 26, 2025, 07:45 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
Sharmaine
8 months ago
Cross-partition queries could slow things down too.
upvoted 0 times
...
Clare
9 months ago
Wait, are we really sure about the hot partition thing?
upvoted 0 times
...
Ashanti
9 months ago
Definitely a risk of hitting max partition key values!
upvoted 0 times
...
Kerrie
9 months ago
I disagree, it might not exceed storage limits.
upvoted 0 times
...
Darrin
9 months ago
Using order-Date could lead to a hot partition for sure.
upvoted 0 times
...
Alba
10 months ago
I’m a bit confused about the cross-partition queries. Would using order-Date really lead to that, or is it more about how we structure the data?
upvoted 0 times
...
Lelia
10 months ago
I practiced a similar question, and I feel like exceeding the maximum storage per partition might be a concern if we get a lot of orders on the same day.
upvoted 0 times
...
Tashia
10 months ago
I think using order-Date could definitely create a hot partition since most orders will likely cluster around certain dates.
upvoted 0 times
...
Vivienne
10 months ago
I remember something about partition keys affecting performance, but I'm not sure if order-Date would lead to a hot partition or not.
upvoted 0 times
...
Stevie
10 months ago
Using order-Date as the partition key might also result in cross-partition queries, which could impact performance. I'll need to weigh the pros and cons of that approach.
upvoted 0 times
...
Goldie
10 months ago
Okay, I think I've got a strategy here. If we get one million orders daily, that could lead to a hot partition issue with order-Date as the key. I'll need to consider that carefully.
upvoted 0 times
...
Malcolm
10 months ago
Hmm, I'm a bit confused about the maximum storage per partition. I'll need to review that part of the Azure Cosmos DB documentation.
upvoted 0 times
...
Ashanti
10 months ago
This seems like a tricky question. I'll need to think carefully about the effects of using order-Date as the partition key.
upvoted 0 times
...
Carol
1 year ago
Wait, a million orders per day? That's like, a new order every 0.086 seconds. I hope the Azure Cosmos DB team has their coffee ready for that kind of load!
upvoted 0 times
Rebecka
1 year ago
C) There will always be a hot partition.
upvoted 0 times
...
Buck
1 year ago
A) You will exceed the maximum number of partition key values.
upvoted 0 times
...
...
Marsha
1 year ago
I think we should consider other partition key options to avoid hot partition problem.
upvoted 0 times
...
Jerry
1 year ago
That's true, but we also need to consider the potential hot partition issue.
upvoted 0 times
...
Tamesha
1 year ago
Ooh, I bet the queries will run cross-partition if we use order-Date. That's not going to be fun for the customers trying to view their order history.
upvoted 0 times
Chan
1 year ago
D) Queries will run cross-partition.
upvoted 0 times
...
Nickole
1 year ago
Yeah, having a hot partition will definitely impact performance.
upvoted 0 times
...
Myra
1 year ago
C) There will always be a hot partition.
upvoted 0 times
...
Marya
1 year ago
A) You will exceed the maximum number of partition key values.
upvoted 0 times
...
...
Yuette
1 year ago
But wouldn't using order-Date as the partition key help with querying past order history efficiently?
upvoted 0 times
...
Marsha
1 year ago
I agree with Jerry, hot partition can lead to performance problems.
upvoted 0 times
...
Tamekia
2 years ago
Hmm, exceeding the maximum storage per partition is also a concern. With a million orders per day, that 2 KB limit will be reached pretty quickly.
upvoted 0 times
...
Willow
2 years ago
Using order-Date as the partition key could definitely lead to a hot partition, as all the new orders will be written to the same partition. That could be a real headache!
upvoted 0 times
Gregoria
1 year ago
User 2
upvoted 0 times
...
Jacqueline
1 year ago
User 2
upvoted 0 times
...
Carman
2 years ago
User 1
upvoted 0 times
...
Bev
2 years ago
User 1
upvoted 0 times
...
...
Jerry
2 years ago
I think using order-Date as the partition key will cause hot partition issue.
upvoted 0 times
...

Save Cancel