Microsoft Exam DP-203 Topic 3 Question 11 Discussion

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?