Microsoft
DP-203 · Question #76
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 th
Sign in or unlock DP-203 to reveal the answer and full explanation for question #76. The question stem and answer options stay visible for context.
Submitted by sofia.br· Mar 30, 2026Design and implement data storage
Question
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:
- 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?
Exhibit
Options
- AProductCategoryTypeID
- BEventDate
- CWarehouseID
- DEventTypeID
Unlock DP-203 to see the answer
You've previewed enough free DP-203 questions. Unlock DP-203 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#partition strategy#columnstore index#query optimization#Synapse dedicated pool