DataDriven
LearnPracticeInterviewDiscussDailyJobs

Design a Type 3 SCD for a product dimension

A medium 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
medium

Interview Prompt

Design a Type 3 SCD for a product dimension. Keep the current category and the previous category in separate columns. This tracks one level of history without adding rows.

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

Related

  • All Mock Interviews
  • Practice Mode (untimed)
  • Data Modeling Interview Questions
  • Data Engineering Interview Prep Guide
  • Practice Problems
  • Daily Challenge