MicrosoftMicrosoft
DP-600 · Question #127
DP-600 Question #127: Real Exam Question with Answer & Explanation
Sign in or unlock DP-600 to reveal the answer and full explanation for question #127. The question stem and answer options stay visible for context.
Submitted by layla.eg· Apr 18, 2026Prepare data
Question
You have a Fabric tenant that contains a data warehouse. You need to load rows into a large Type 2 slowly changing dimension (SCD). The solution must minimize resource usage. Which T-SQL statement should you use?
Options
- AUPDATE AND INSERT
- BMERGE
- CTRUNCATE TABLE and INSERT
- DCREATE TABLE AS SELECT
Unlock DP-600 to see the answer
You've previewed enough free DP-600 questions. Unlock DP-600 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Slowly Changing Dimensions (SCD)#MERGE statement#Data Warehousing#T-SQL optimization