Exam DP-420 topic 1 question 32 discussion

Actual exam question from Microsoft's DP-420

Question #: 32
Topic #: 1

You have an Azure Cosmos DB database.

You plan to create a new container named container1 that will store product data and product category data and will primarily support read requests.

You need to configure a partition key for container1. The solution must meet the following requirements:

• Minimize the size of the partition.
• Minimize maintenance effort.

Which two characteristics should you prioritize? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A. unique
B. high cardinality
C. low cardinality
D. static

Show Suggested Answer

Suggested Answer: BD 🗳️

by azuredemo2022three at June 28, 2023, 8:40 p.m.

Comments

Submit Cancel

azuredemo2022three

Highly Voted 1 year, 7 months ago

Selected Answer: BD

To configure a partition key for container1 in Azure Cosmos DB, prioritizing characteristics that minimize the size of the partition and maintenance effort, you should prioritize the following two characteristics: B. High cardinality: Choosing a partition key with high cardinality means having a large number of unique values distributed across the dataset. This helps in distributing the data evenly across multiple partitions, preventing hotspots and ensuring efficient scalability. D. Static: Selecting a static partition key means choosing a key that does not frequently change. This minimizes the need for updates to the partition key value and reduces maintenance effort. It also helps in maintaining a consistent distribution of data across partitions over time. So, the correct answers are: B. High cardinality D. Static

upvoted 11 times

...

xRiot007

Most Recent 1 year, 1 month ago

B,D - considering products have category data, we can expect the category to be a filter, which makes it a good candidate to be a partition key. Categories are static known terms for a given business (values like "Electronics", "Clothing", "Wellness" etc)

upvoted 1 times

...