Data Engineering on Microsoft Azure — Question 52

You have an Azure Synapse Analytics dedicated SQL pool.

You plan to create a fact table named Table1 that will contain a clustered columnstore index.

You need to optimize data compression and query performance for Table1.

What is the minimum number of rows that Table1 should contain before you create partitions?

Answer options

• A. 100,000
• B. 600,000
• C. 1 million
• D. 60 million

Correct answer: D

Explanation

The correct answer is D because a minimum of 60 million rows is recommended for effective partitioning in a clustered columnstore index in Azure Synapse Analytics to optimize both data compression and query performance. Options A, B, and C do not meet the minimum threshold necessary for partitioning to be beneficial in this context.