Microsoft
DP-203 · Question #82
You are designing a partition strategy for a fact table in an Azure Synapse Analytics dedicated SQL pool. The table has the following specifications: - Contain sales data for 20,000 products. - Use ha
Sign in or unlock DP-203 to reveal the answer and full explanation for question #82. The question stem and answer options stay visible for context.
Submitted by kwame.gh· Mar 30, 2026Design and implement data storage
Question
You are designing a partition strategy for a fact table in an Azure Synapse Analytics dedicated SQL pool. The table has the following specifications:
- Contain sales data for 20,000 products.
- Use hash distribution on a column named ProduclID,
- Contain 2.4 billion records for the years 20l9 and 2020.
Which number of partition ranges provides optimal compression and performance of the clustered columnstore index?
Options
- A40
- B240
- C400
- D2,400
Unlock DP-203 to see the answer
You've previewed enough free DP-203 questions. Unlock DP-203 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#partition count optimization#columnstore index compression#hash distribution#rowgroup sizing