BenchMark Quizzes by MDFT Pro

Choose the correct T-SQL statement

MDFT Pro has a Fabric tenant that contains a data warehouse for tracking student enrollment history. As a data analyst at MDFT Pro, you need to load rows into a large Type 1 slowly changing dimension (SCD) that tracks student status changes.

The solution must minimize resource usage to ensure efficient processing of the student data. Which T-SQL statement should you use?

Choose the correct answer from the options below.

Explanations for each answer:

UPDATE AND INSERT is incorrect. While UPDATE and INSERT statements could track student status changes, they require multiple statements. This is not the most efficient solution.
MERGE is correct.
TRUNCATE TABLE and INSERT is incorrect. TRUNCATE TABLE and INSERT would delete all existing student enrollment data and reload everything, This statement is more suited for refreshing entire tables rather than updating specific student enrollment records.
CREATE TABLE AS SELECT is incorrect. CREATE TABLE AS SELECT would create a new table with the selected student data. This statement is more suited for creating new tables rather than updating specific student enrollment records.

Learn more about MERGE statement:

Merge Statement

Exam Preparation Quiz

Choose the correct T-SQL statement