What should you do?

You have an Azure Synapse Analytics dedicated SQL Pool 1. 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?
A . Switch the first partition from dbo.Sales to stg.Sales.
B . Switch the first partition from stg.Sales to dbo. Sales.
C . Update dbo.Sales from stg.Sales.
D . Insert the data from stg.Sales into dbo.Sales.

Answer: A

Latest DP-203 Dumps Valid Version with 116 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments