New Year Sale 2026! 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 10 Question 44 Discussion

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

You have a database named db1 in an Azure Cosmos DB for NoSQL

You are designing an application that will use dbl.

In db1, you are creating a new container named coll1 that will store in coll1.

The following is a sample of a document that will be stored in coll1.

The application will have the following characteristics:

* New orders will be created frequently by different customers.

* Customers will often view their past order history.

You need to select the partition key value for coll1 to support the application. The solution must minimize costs.

To what should you set the partition key?

Show Suggested Answer Hide Answer
Suggested Answer: A

by Shawn at Jul 17, 2024, 08:59 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
Carin
3 months ago
I’ve heard customerId is the go-to for minimizing costs in this scenario.
upvoted 0 times
...
In
3 months ago
Wait, why not use orderDate? Seems like it could work too!
upvoted 0 times
...
Francoise
3 months ago
Not sure about that, orderId could be more efficient for unique access.
upvoted 0 times
...
Dottie
4 months ago
Definitely agree, it helps with order history retrieval!
upvoted 0 times
...
Vivan
4 months ago
I think customerId is the best choice for the partition key.
upvoted 0 times
...
Sueann
4 months ago
I was leaning towards orderId, but now I wonder if it would create too many partitions. I guess customerId could balance the load better.
upvoted 0 times
...
Kristine
4 months ago
I practiced a similar question where we had to choose a partition key for user data. I think id might not be ideal since it doesn't group related data together.
upvoted 0 times
...
Edward
4 months ago
I'm not entirely sure, but I feel like using orderDate could lead to issues with hot partitions, especially if many orders come in on the same day.
upvoted 0 times
...
Hillary
5 months ago
I remember we discussed how partition keys can affect performance and cost. I think customerId might be a good choice since it can help group orders by customer.
upvoted 0 times
...
Lang
5 months ago
The "id" option seems tempting, but I don't think that would be the best choice here. We want to optimize for querying order history, so "customerId" is probably the way to go.
upvoted 0 times
...
Marjory
5 months ago
I'm leaning towards the "customerId" option. That seems like it would allow us to efficiently query a customer's past orders, which is one of the key application requirements.
upvoted 0 times
...
Zack
5 months ago
Okay, let's see. The question says new orders will be created frequently by different customers, and customers will often view their past order history. I think the partition key should be something that allows efficient querying of a customer's order history.
upvoted 0 times
...
Maryanne
5 months ago
Hmm, I'm a bit unsure about this one. The sample document has a lot of different fields, and I'm not sure which one would be the best partition key.
upvoted 0 times
...
Stephane
5 months ago
This looks like a classic Azure Cosmos DB partition key selection question. I'll need to think carefully about the application characteristics and how to optimize for cost.
upvoted 0 times
...
Carole
5 months ago
I've seen questions like this before, so I think I know what to look for. The key is to identify which commands Jane can run without a password, and which ones require her password or the root password.
upvoted 0 times
...
Delsie
5 months ago
Ah, I see. The question is asking about a specific requirement, so I'll need to pay close attention to the details in each option. Knowing the right Kubernetes version and having the Ezmeral ML Ops package installed seem like important factors to consider.
upvoted 0 times
...
Helene
9 months ago
I'd set the partition key to 'hasCoupon'. That way, the database will always know which orders have coupons and which don't. *winks*
upvoted 0 times
...
Rochell
9 months ago
The partition key should be 'id', of course! That's the most common and reliable choice for any database, right? *chuckles* Just kidding, 'customerId' is probably the way to go here.
upvoted 0 times
Rory
8 months ago
Definitely 'customerId', it aligns with the frequent order creation and order history viewing.
upvoted 0 times
...
Della
8 months ago
'customerId' seems like the logical choice to keep related data together.
upvoted 0 times
...
Lavelle
8 months ago
I think 'customerId' would work well to group orders by customer.
upvoted 0 times
...
Leonor
9 months ago
Agreed, 'customerId' makes the most sense for this scenario.
upvoted 0 times
...
...
Jacquelyne
9 months ago
Hmm, I'm not sure. 'orderDate' might be a good option to group orders chronologically and support the order history feature. But I guess 'customerId' is the safest choice.
upvoted 0 times
...
Glenna
10 months ago
I would go with 'orderId' as the partition key. This way, each order is isolated and can be accessed quickly, which is important for the application's performance.
upvoted 0 times
...
Hoa
10 months ago
Setting the partition key to 'customerId' makes the most sense to me. This will allow Azure Cosmos DB to efficiently distribute the data and handle the frequent creation of new orders and customers viewing their past orders.
upvoted 0 times
Lynda
9 months ago
Definitely 'customerId' for the partition key, it aligns well with the application requirements.
upvoted 0 times
...
Aimee
9 months ago
I think 'customerId' is the most logical option for the partition key.
upvoted 0 times
...
Fannie
9 months ago
I agree, setting the partition key to 'customerId' would be the best choice.
upvoted 0 times
...
...
Dick
10 months ago
That makes sense too. We need to consider both factors to minimize costs.
upvoted 0 times
...
Nu
11 months ago
I disagree, I believe we should set the partition key to orderId because new orders will be created frequently by different customers.
upvoted 0 times
...
Dick
11 months ago
I think we should set the partition key to customerId because customers will often view their past order history.
upvoted 0 times
...

Save Cancel