Exam DP-203 topic 1 question 33 discussion

The correct answer is C

this must be C. since the need is to overwrite dbo.Sales with the content of stg.Sales. SWITCH source TO target

Pour remplacer le contenu de la première partition dans dbo.Sales par le contenu de la même partition dans stg.Sales tout en minimisant les temps de chargement, vous devez basculer la première partition de stg.Sales vers dbo.Sales (C). Cette méthode est efficace car elle utilise le basculement de partition, qui est une opération rapide et minimise les temps d'arrêt et de chargement par rapport à l'insertion ou à la mise à jour des données.

Correct Answer: C

The correct answer is C

As switching partition does not involve movement of data, dbo.sales partition should be switched to the partition of stg.Sales so that partition from stg.Sales will be available in dbo.Sales

must be c

it's C

(C) because By switching the first partition from stg.Sales to dbo.Sales, you effectively replace the content of the first partition in dbo.Sales with the content of the corresponding partition in stg.Sales. This approach ensures that the partition in dbo.Sales is updated almost instantly, with minimal load time. Incorrect Options: A. Insert the data: Inserting data into dbo.Sales from stg.Sales would involve more overhead, as it requires data movement and processing, which can be time-consuming. B. Switch the first partition from dbo.Sales to stg.Sales: This would move the data out of dbo.Sales but would not achieve the goal of updating dbo.Sales with the data from stg.Sales. D. Update dbo.Sales: Updating the data would involve reading and writing the data, which would take significantly more time compared to partition switching.

SWITCH [ PARTITION source_partition_number_expression ] TO [ schema_name. ] target_table [ PARTITION target_partition_number_expression ] SOURCE TO DETENTION

actually B is correct. We have to understand the sentence as: Change the content of the first partition of dbo.Sales with the content of the first partition of stage.Sales. Thus, switch the content of first partition of dbo.Sales to/with the first partition of stage.Sales.

Logical is C

B is correct ALTER TABLE FactInternetSales SWITCH PARTITION 2 TO FactInternetSales_20000101 PARTITION 2; ALTER TABLE FactInternetSales SPLIT RANGE (20010101); https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-partition?context=%2Fazure%2Fsynapse-analytics%2Fcontext%2Fcontext

Response is B

The correct answer is C

switch the first partition of sales to stage.sales's partition

it is the way on wording....tricky. might be not native speaker or they shall ask differt way...