DP-203 · Question #50
DP-203 Question #50: Real Exam Question with Answer & Explanation
In Azure Synapse Analytics dedicated SQL pools, creating a partitioned table requires specifying both the DISTRIBUTION clause (to define how data is distributed across compute nodes, e.g., HASH, ROUND_ROBIN, or REPLICATE) and the PARTITION clause (to define the table partitioning
Question
Drag and Drop Question You need to create a partitioned table in an Azure Synapse Analytics dedicated SQL pool. How should you complete the Transact-SQL statement? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Answer:
Explanation
In Azure Synapse Analytics dedicated SQL pools, creating a partitioned table requires specifying both the DISTRIBUTION clause (to define how data is distributed across compute nodes, e.g., HASH, ROUND_ROBIN, or REPLICATE) and the PARTITION clause (to define the table partitioning scheme using a partition function and boundary values). The correct T-SQL syntax follows the pattern: CREATE TABLE ... WITH (DISTRIBUTION = [type], PARTITION ([column] RANGE [LEFT|RIGHT] FOR VALUES ([values]))). These two WITH clause options are specific to Synapse dedicated pools and work together to optimize query performance and data management.
Topics
Community Discussion
No community discussion yet for this question.