Microsoft Exam DP-420 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

Carol

3 months 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

3 months ago

C) There will always be a hot partition.

upvoted 0 times

...

Buck

3 months ago

A) You will exceed the maximum number of partition key values.

upvoted 0 times

...

Marsha

3 months ago

I think we should consider other partition key options to avoid hot partition problem.

upvoted 0 times

...

Jerry

3 months ago

That's true, but we also need to consider the potential hot partition issue.

upvoted 0 times

...

Tamesha

3 months 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

2 months ago

D) Queries will run cross-partition.

upvoted 0 times

...

Nickole

3 months ago

Yeah, having a hot partition will definitely impact performance.

upvoted 0 times

...

Myra

3 months ago

C) There will always be a hot partition.

upvoted 0 times

...

Marya

3 months ago

A) You will exceed the maximum number of partition key values.

upvoted 0 times

...

Yuette

4 months ago

But wouldn't using order-Date as the partition key help with querying past order history efficiently?

upvoted 0 times

...

Marsha

4 months ago

I agree with Jerry, hot partition can lead to performance problems.

upvoted 0 times

...

Tamekia

4 months 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

4 months 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