Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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
