DP-203 · Question #279
DP-203 Question #279: Real Exam Question with Answer & Explanation
The correct answer is A: once per month. Considering the high volume of data, for faster queries its recommended to create fewer " If a table contains fewer than the recommended minimum number of rows per partition(i.e. 60 million rows per month for 60 distributed partitions, consider using fewer partitions in order to
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
Explanation
Considering the high volume of data, for faster queries its recommended to create fewer " If a table contains fewer than the recommended minimum number of rows per partition(i.e. 60 million rows per month for 60 distributed partitions, consider using fewer partitions in order to increase the number of rows per partition."
Community Discussion
No community discussion yet for this question.