
Ultimate access to all questions.
You are designing an inventory updates table with a clustered columnstore index in an Azure Synapse Analytics dedicated SQL pool. The table has the following columns:
WarehouseID
ProductCategoryType
Date
InventoryEventType
Quantity
The identified usage patterns are:
Analysts will most commonly analyze transactions for a specific warehouse.
Queries will summarize data by product category type, date, and/or inventory event type.
To minimize query times, on which column should you partition the table?

A
EventTypeID
B
ProductCategoryTypeID
C
EventDate
D
WarehouseID