The Change Data Capture
A hard Python mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- Python
- Difficulty
- hard
- Seniority
- L5
Interview Prompt
Given old_snapshot, new_snapshot (lists of dicts keyed by id_field), return a dict with four sorted lists: 'added' (records in new only), 'removed' (in old only), 'unchanged' (identical across both), 'modified' (same id, different other fields). Sort each list by id_field ascending.
Summary
Inserts, updates, deletes : all present.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your python solution with real code execution
- Get instant feedback and a hire/no-hire decision