Loading interview...

SCD Type 2 Customer Dimension

A hard Data Modeling mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.

Domain
Data Modeling
Difficulty
hard
Seniority
senior

Interview Prompt

Our customer dimension needs to track historical changes to attributes like address, membership tier, and email. When we look at an order from 6 months ago, we need the customer's attributes as of that date, not today's values. Design the schema.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write your data modeling solution with real code execution
  4. Get instant feedback and a hire/no-hire decision