DP-203 · Question #81
DP-203 Question #81: Real Exam Question with Answer & Explanation
Sign in or unlock DP-203 to reveal the answer and full explanation for question #81. The question stem and answer options stay visible for context.
Question
You have an Azure Synapse Analytics dedicated SQL Pool1. Pool1 contains a partitioned fact table named dbo.Sales and a staging table named stg.Sales that has the matching table and partition definitions. You need to overwrite the content of the first partition in dbo.Sales with the content of the same partition in stg.Sales. The solution must minimize load times. What should you do?
Options
- ASwitch the first partition from dbo.Sales to stg.Sales.
- BSwitch the first partition from stg.Sales to dbo. Sales.
- CUpdate dbo.Sales from stg.Sales.
- DInsert the data from stg.Sales into dbo.Sales.
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.