DP-203 · Question #206
DP-203 Question #206: Real Exam Question with Answer & Explanation
Sign in or unlock DP-203 to reveal the answer and full explanation for question #206. The question stem and answer options stay visible for context.
Question
You have an Azure Synapse Analytics dedicated SQL pool. You need to Create a fact table named Table1 that will store sales data from the last three years. The solution must be optimized for the following query operations: - Show order counts by week. - Calculate sales totals by region. - Calculate sales totals by product. - Find all the orders from a given month. Which data should you use to partition Table1?
Options
- Aregion
- Bproduct
- Cweek
- Dmonth
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.