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.

AYou will exceed the maximum number of partition key values.

BYou will exceed the maximum storage per partition.

CThere will always be a hot partition.

DQueries will run cross-partition.

Show Suggested 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:

Submit Cancel

Sharmaine

5 months ago

Cross-partition queries could slow things down too.

upvoted 0 times

...

Clare

5 months ago

Wait, are we really sure about the hot partition thing?

upvoted 0 times

...

Ashanti

5 months ago

Definitely a risk of hitting max partition key values!

upvoted 0 times

...

Kerrie

5 months ago

I disagree, it might not exceed storage limits.

upvoted 0 times

...

Darrin

6 months ago

Using order-Date could lead to a hot partition for sure.

upvoted 0 times

...

Alba

6 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

6 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

6 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

6 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

6 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

6 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

6 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

7 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

1 year 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

1 year 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