Microsoft Azure Data Engineer Associate - DP-203
Get started today
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?
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?
Exam-Like
A
Insert the data from stg.Sales into dbo.Sales.
8.3%
B
Switch the first partition from dbo.Sales to stg.Sales.
16.7%
C
Comments
Loading comments...