What is the main purpose of implementing Slowly Changing Dimension (SCD) Type 2 in a data warehouse?

easy🧠 Conceptual Q11 of 15

dbt - Advanced Patterns

ATo keep full history of changes by adding new rows for each change

BTo overwrite old data with new data without keeping history

CTo delete old records when data changes

DTo aggregate data for faster queries

Step-by-Step Solution

Solution:

Step 1: Understand SCD Type 2 concept
SCD Type 2 tracks changes by adding new rows instead of overwriting existing data.
Step 2: Compare options with concept
Only To keep full history of changes by adding new rows for each change describes adding new rows to keep full history, which matches SCD Type 2.
Final Answer:
To keep full history of changes by adding new rows for each change -> Option A
Quick Check:
SCD Type 2 = Add new rows for history [OK]

Quick Trick: Remember: SCD Type 2 adds rows, not overwrites [OK]

Common Mistakes:

MISTAKES

Master "Advanced Patterns" in dbt

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More dbt Quizzes