DP-203 · Question #76
DP-203 Question #76: Real Exam Question with Answer & Explanation
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.
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?
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.