
Ultimate access to all questions.
You are designing a financial transactions table with a clustered columnstore index in an Azure Synapse Analytics dedicated SQL pool. The table has the following columns and estimated rows per value:
The query requirements are:
You need to recommend a partitioning column for the table to minimize query times. Which column should you choose?

A
CustomerSegment
B
AccountType
C
TransactionType
D
TransactionMonth