In SCD Type 2, what is the role of the 'effective_date' column?

easy🧠 Conceptual Q2 of 15

dbt - Advanced Patterns

ATo store the last update timestamp only

BTo mark when a record version became valid

CTo identify the primary key of the record

DTo count the number of changes

Step-by-Step Solution

Solution:

Step 1: Define 'effective_date' in SCD Type 2 and evaluate options
This column shows when a particular version of a record started being valid. To mark when a record version became valid correctly describes this role, while others do not match the purpose.
Final Answer:
To mark when a record version became valid -> Option B
Quick Check:
effective_date = version start time [OK]

Quick Trick: effective_date shows when data version starts [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