
Ultimate access to all questions.
You have an Azure Synapse Analytics dedicated SQL pool named Pool1 containing a partitioned fact table named dbo.Sales and a staging table named stg.Sales with identical table and partition schemas. You need to overwrite the content of the first partition in dbo.Sales with the content of the corresponding partition in stg.Sales while minimizing load times. What should you do?