Databricks Certified Data Engineer - Professional

Ultimate access to all questions.

When comparing two versions of a Delta Lake table before and after an update, which Slowly Changing Dimension (SCD) Type does this table represent?

Before:

user_id name address city
001 John 4, Oxford Street London
002 Sarah 99, Victor Hugo Street Paris

After:

user_id name address city
001 John 25, King's Road London
002 Sarah 99, Victor Hugo Street Paris

user_id	name	address	city
001	John	4, Oxford Street	London
002	Sarah	99, Victor Hugo Street	Paris

user_id	name	address	city
001	John	25, King's Road	London
002	Sarah	99, Victor Hugo Street	Paris

Real Exam