
Ultimate access to all questions.
You have an Azure Synapse Analytics dedicated SQL pool with a fact table named Table1 that will use a clustered columnstore index. To optimize data compression and query performance, what is the minimum number of rows Table1 should have before creating partitions?
A
100,000
B
600,000
C
1 million
D
60 million