Data Engineering on Microsoft Azure — Question 125

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?

Answer options

• A. 1 million
• B. 5 million
• C. 20 million
• D. 60 million

Correct answer: A

Explanation

The correct answer is A, as with round-robin distribution, the data is evenly distributed across the distributions. Given that the table will have about 60 million rows per month, and assuming the default of 60 distributions, approximately 1 million rows will fall into each distribution per month.