Câu 90: DP-203: Data Engineering on Microsoft Azure

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: You identify the following usage patterns: ✑ Analysts 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 partition the table?

1. A. EventTypeID
2. B. ProductCategoryTypeID
3. C. EventDate
4. D. WarehouseID — đáp án hiện tại