You are designing a sales transactions table in an Azure Synapse Analytics dedicated SQL pool. The table will contain approximately 60 million rows per month and will be partitioned by month. The tabl

The correct answer is A. 1 million. Azure Synapse Analytics dedicated SQL pools distribute data across multiple distributions - by default, there are 60 distributions. Since the sales transactions table will be partitioned by month and will contain approximately 60 million rows per month, and considering round-robi

Submitted by anna_se· Mar 30, 2026Design and implement data storage

Question

You are designing a sales transactions table in an Azure Synapse Analytics dedicated SQL pool. The table will contain approximately 60 million rows per month and will be partitioned by month. The table will use a clustered column store index and round-robin distribution. Approximately how many rows will there be for each combination of distribution and partition?

Options

A1 million
B5 million
C20 million
D60 million

How the community answered

(56 responses)

A
71% (40)
B
16% (9)
C
4% (2)
D
9% (5)

Explanation

Azure Synapse Analytics dedicated SQL pools distribute data across multiple distributions - by default, there are 60 distributions. Since the sales transactions table will be partitioned by month and will contain approximately 60 million rows per month, and considering round-robin distribution is used (which distributes rows evenly across all distributions), we can estimate the number of rows per combination of distribution and partition by dividing the total number of rows by the number of distributions. 60 million rows per month / 60 distributions = 1 million rows per distribution per month.

Topics

#round-robin distribution#table partitioning#row distribution calculation#columnstore index

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice