DP-203 · Question #82
DP-203 Question #82: Real Exam Question with Answer & Explanation
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.
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.