Exam DP-600 topic 1 question 125 discussion

MERGE is not currently supported in Fabric: https://learn.microsoft.com/en-us/fabric/data-warehouse/tsql-surface-area#limitations so it must be UPDATE and INSERT C – TRUNCATE TABLE AND INSERT would eliminate history (which is the whole point of SCD Type 2) D – CREATE TABLE AS SELECT – this can be used for an initial load if the table doesn’t exist, but it won’t work for an SCD Type 2 because it would eliminate retention of historical changes.

Normally I would say its MERGE. However MERGE is not currently supported by Fabric (I think its due to be GA Q1 2025),so the answer needs to be UPDATE and INSERT.

for efficiently managing the inserts and updates required for a large Type 2 SCD while minimizing resource usage, the MERGE statement is the standard and recommended T-SQL approach. The final answer is B

Merg allow you to do : -Insert new records for changes. -Update existing records to mark them as historical. -Maintain the history of changes efficiently.

Its a merge with merge you can define what happens after the merge