DP-420 · Question #59
You work in the Intel company that has its clients across 4 different countries, with hundreds of thousands of clients for countries 1 and 2, and a few thousand clients for countries 3 and 4…
The correct answer is B. This partition key could cause storage hot partitions. With only 4 distinct countryId values and a heavily skewed distribution (hundreds of thousands of clients in countries 1 and 2 vs. a few thousand in 3 and 4), the logical partitions for countries 1 and 2 will accumulate far more data than the others, causing storage hot…
Question
You work in the Intel company that has its clients across 4 different countries, with hundreds of thousands of clients for countries 1 and 2, and a few thousand clients for countries 3 and 4. Requests for every country total approximately 50,000 RU/s every hour of the day. The application team of the company suggests using countryId as the partition key for this container. Which of the following statements is true?
Options
- AThis partition key will cause fan out when filtering by countryId
- BThis partition key could cause storage hot partitions
- CThis partition key will prevent throughput hot partitions
- DAll the above
How the community answered
(63 responses)- A2% (1)
- B84% (53)
- C5% (3)
- D10% (6)
Explanation
With only 4 distinct countryId values and a heavily skewed distribution (hundreds of thousands of clients in countries 1 and 2 vs. a few thousand in 3 and 4), the logical partitions for countries 1 and 2 will accumulate far more data than the others, causing storage hot partitions. Option A is wrong because filtering by countryId would actually be efficient - data is co-located by that key, so no fan-out occurs. Option C is wrong because throughput is described as ~50,000 RU/s per country, but unequal data volume still creates storage imbalance regardless of even throughput distribution.
Topics
Community Discussion
No community discussion yet for this question.