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?