History Erased
A medium AI Coding mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- AI Coding
- Difficulty
- medium
- Seniority
- L5
Interview Prompt
dim_customer is supposed to be SCD-2: every change to address/email creates a new row with effective_from / effective_to and is_current. After today's incremental run, the table has exactly one row per customer , history wiped. Run tests/test_scd2_history.py to reproduce. Fix sql/merge_dim_customer.sql so changes append a new version and close the old one, instead of overwriting.
Summary
Yesterday never happened.
How This Interview Works
- Read the task and the repository: the files, the failing check and the constraints
- Work the fix with the AI agent at your side, and run the checks until they pass
- Submit, then answer the interviewer's questions about the change you made
- Get a hire or no-hire decision with feedback on how you drove the agent