DP-203 · Question #81
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 definitio
The correct answer is B. Switch the first partition from stg.Sales to dbo. Sales.. The best option for overwriting the content of the first partition in dbo.Sales with the content of the same partition in stg.Sales and minimizing load times would be to switch the first partition from stg.Sales to dbo.Sales. Switching partitions is a common approach to efficient
Question
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?
Options
- ASwitch the first partition from dbo.Sales to stg.Sales.
- BSwitch the first partition from stg.Sales to dbo. Sales.
- CUpdate dbo.Sales from stg.Sales.
- DInsert the data from stg.Sales into dbo.Sales.
How the community answered
(43 responses)- A16% (7)
- B70% (30)
- C5% (2)
- D9% (4)
Explanation
The best option for overwriting the content of the first partition in dbo.Sales with the content of the same partition in stg.Sales and minimizing load times would be to switch the first partition from stg.Sales to dbo.Sales. Switching partitions is a common approach to efficiently manage large tables in SQL Server. By using the ALTER TABLE SWITCH statement, it is possible to quickly move data between tables with minimal overhead. In this scenario, switching the first partition from stg.Sales to dbo.Sales will replace the data in the first partition of dbo.Sales with the data from the corresponding partition in stg.Sales.
Topics
Community Discussion
No community discussion yet for this question.