Implementing Slowly Changing Dimensions (SCD) with Databricks Lakeflow Pipelines and Connect

Why SCD is NOT dead!

I’ve spent the last several months interviewing candidates for Senior Data Engineer positions. I’ve seen some outstanding resumes for people that couldn’t answer this foundational question. Explain SCDs and when you would use each one.