Microsoft Exam DP-203 Topic 8 Question 37 Discussion

I think the answer is also A, but for different justification: 1) Microsoft article states that, "When creating partitions on clustered columnstore tables, it is important to consider how many rows belong to each partition. For optimal compression and performance of clustered columnstore tables, a minimum of 1 million rows per distribution and partition is needed. Before partitions are created, dedicated SQL pool already divides each table into 60 distributed databases. (https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-partition) 2) When calculating the number of partitions another article states, "Having too many partitions can reduce the effectiveness of clustered columnstore indexes if each partition has fewer than 1 million rows. Dedicated SQL pools automatically partition your data into 60 databases. So, if you create a table with 100 partitions, the result will be 6000 partitions." (https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/best-practices-dedicated-sql-pool) Thus, if the equation to determine optimal compression and performance of the clustered columnstore index is [2.4 billion / (60*partition range)] >= 1,000,000; then the answer is 40. Anything else results in a number less than 1,000,000

answer is A.... 2.4 B / 40 = 60 M.....which is most optimum