Microsoft
DP-203 · Question #279
You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Table1. Table1 contains the following: - One billion rows - A clustered columnstore index - A hash-distributed column
Sign in or unlock DP-203 to reveal the answer and full explanation for question #279. The question stem and answer options stay visible for context.
Submitted by luis.pe· Mar 30, 2026Design and implement data storage
Question
You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Table1. Table1 contains the following:
- One billion rows
- A clustered columnstore index
- A hash-distributed column named Product Key
- A column named Sales Date that is of the date data type and cannot be
null Thirty million rows will be added to Table1 each month. You need to partition Table1 based on the Sales Date column. The solution must optimize query performance and data loading. How often should you create a partition?
Options
- Aonce per month
- Bonce per year
- Conce per day
- Donce per week
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
#table partitioning#Azure Synapse#query performance#data loading optimization