A batch ETL processes 10,000 rows
A medium Pipeline Design mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- Pipeline Design
- Difficulty
- medium
Interview Prompt
A batch ETL processes 10,000 rows. One row fails. Two extreme answers are both wrong: failing the entire batch loses progress on every good row, and silently dropping the bad row hides what may be a symptom of a larger issue. The section names three strategies: all-or-nothing (depends on idempotency), skip-and-quarantine (a percentage threshold guards the failure), and partial commit with checkpoint (resume from the last committed unit). Pick the strategy that fits this analytics workload by replacing the ingest transform's name with one that states the chosen strategy and its bounding parameter. If skip-and-quarantine is chosen, add a quarantine destination.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your pipeline design solution with real code execution
- Get instant feedback and a hire/no-hire decision