Data CleaningHard
Explain slowly changing dimensions (SCD) and when you need them.
Seen at: Meta · Airbnb · Netflix
Your customers table has columns like billing_address, plan_tier, and segment. A customer's plan tier changed last month. A report from 6 months ago uses the current plan tier. How do you handle this?
Draft your answer
Saved to this browser only. Try it before you peek at the model answer.
Reveals the model answer and the self-score rubric.