ATMAE Certified Technical Professional (CTP)

Which approach best handles slowly changing dimensions (SCD) in a data warehouse?

SCD Type 2: adding new rows with effective date ranges Deleting old records and inserting new ones Storing only the latest value in a flat table Using real-time streaming for all historical data

Correct Answer:

SCD Type 2: adding new rows with effective date ranges

Access more questions from this quiz

Continue to ATMAE Certified Technical Professional (CTP) for more practice questions and the full quiz experience.

Access More Questions