What should you do?

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?
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.

View Answer

Answer: B