MicrosoftMicrosoft
DP-203 · Question #247
DP-203 Question #247: Real Exam Question with Answer & Explanation
Sign in or unlock DP-203 to reveal the answer and full explanation for question #247. The question stem and answer options stay visible for context.
Submitted by helene.fr· Mar 30, 2026
Question
You have been assigned the task of partitioning the FactOnlineSales table on the OrderDateKey column in the dedicated SQL pool. For this purpose, you decide to use the CREATE TABLE statement. Complete the statement by filling the blanks with the right words.
Options
- ADistribution and Partition
- BDistributionTable and PartitionTable
- CDistribution and Collate
- DPartition and Distribution
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.