On which column should you recommend partitioning the table?

You are designing an inventory updates table in an Azure Synapse Analytics dedicated SQL pool.

The table will have a clustered columnstore index and will include the following columns:

• EventDate: 1 million per day

• EventTypelD: 10 million per event type

• WarehouselD: 100 million per warehouse

• ProductCategoryTypeiD: 25 million per product category type

You identify the following usage patterns:

Analyst will most commonly analyze transactions for a warehouse.

Queries will summarize by product category type, date, and/or inventory event type. You need to recommend a partition strategy for the table to minimize query times.

On which column should you recommend partitioning the table?
A . ProductCategoryTypeID
B . EventDate
C . WarehouseID
D . EventTypeID

View Answer

Answer: D