Microsoft Exam DP-203 Topic 10 Question 35 Discussion

Actual exam question for Microsoft's DP-203 exam

Question #: 35
Topic #: 10

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?

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.

Show Suggested Answer

Suggested Answer: D

by Deonna at May 08, 2022, 06:51 AM

Limited Time Offer

25%

Off

Get Premium DP-203 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!