DP-203 practice question 4 of 35
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?
Full set: 354 questionsCorrect Answer:
A. Switch the first partition from dbo.Sales to stg.Sales.
Explanation
:
Keep practicing
Take the free DP-203 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DP-203 practice questions
- Question 1You have an Azure subscription that contains an Azure data factory named ADF1. From Azure…
- Question 2You need to implement the surrogate key for the retail store table. The solution must mee…
- Question 5You need to design a data retention solution for the Twitter feed data records. The solut…
- Question 6You have an Azure Storage account and a data warehouse in Azure Synapse Analytics in the …
- Question 7You plan to implement an Azure Data Lake Storage Gen2 container that will contain CSV fil…
- Question 8You need to design a solution that will process streaming data from an Azure Event Hub an…