Microsoft
DP-203 · Question #371
Drag and Drop Question You have an Azure Synapse Analytics dedicated SQL pool named SQL1 that contains a hash- distributed fact table named Table1. You need to recreate Table1 and add a new distributi
Sign in or unlock DP-203 to reveal the answer and full explanation for question #371. The question stem and answer options stay visible for context.
Submitted by ashley.k· Mar 30, 2026Design and Implement Data Storage - specifically managing and optimizing distributed tables in Azure Synapse Analytics dedicated SQL pools, including zero-downtime schema changes using CTAS and rename patterns.
Question
Drag and Drop Question You have an Azure Synapse Analytics dedicated SQL pool named SQL1 that contains a hash- distributed fact table named Table1. You need to recreate Table1 and add a new distribution column. The solution must maximize the availability of data. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Answer:
Exhibit
Answer Area
Drag items
Create a new table named Table1v2 by running CTAS.Rename Table1v2 as Table1.Rename Table1 as Table1_old.Run DBCC PDW_SHOWSPACEUSED.Drop Table1_old.Drop the indexes of Table1.
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
#Azure Synapse Analytics#Dedicated SQL Pool#CTAS#Hash Distribution#Table Migration