Answer-first summary for fast verification
Answer: UPDATE AND INSERT
The question requires loading rows into a large Type 2 SCD in Fabric data warehouse while minimizing resource usage. Although MERGE (B) is the standard T-SQL approach for efficiently handling SCD Type 2 operations (combining inserts and updates in a single statement), it is not currently supported in Fabric Warehouse according to Microsoft documentation and community consensus. The most upvoted comments (5 and 4 upvotes) confirm this limitation and recommend using UPDATE and INSERT (A) as the practical alternative. Option C (TRUNCATE TABLE and INSERT) would eliminate historical records, violating SCD Type 2 requirements. Option D (CREATE TABLE AS SELECT) is unsuitable for incremental loads as it recreates the entire table. Therefore, A is the correct choice given Fabric's current capabilities.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You have a Fabric tenant containing a data warehouse.
You need to load rows into a large Type 2 slowly changing dimension (SCD) while minimizing resource usage.
Which T-SQL statement should you use?
A
UPDATE AND INSERT
B
MERGE
C
TRUNCATE TABLE and INSERT
D
CREATE TABLE AS SELECT
No comments yet.