You need to partition a large fact table in Azure Synapse dedicated SQL pool to optimize query performance. Which column is typically the best partition key?
-
A
A high-cardinality string column like product name
-
B
A date or datetime column used in most queries
-
C
A foreign key column with low cardinality
-
D
A GUID primary key column