The Bad Row That Broke the Dashboard
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
- Seniority
- L6
Interview Prompt
We run a high-volume application event stream that has to reach Snowflake for analytics within about a minute of arrival, and past releases have let bad records into production tables and broken dashboards, so quality has to be enforced in-flight before anything lands. Records that fail validation can't be silently dropped: they need to be held aside with enough context for engineering to trace the root cause and replay them once it's fixed. Product teams reshape their event fields most weeks, so an incompatible producer change has to be rejected against a registered schema contract right at the source, before it enters the pipeline, rather than allowed to crash it or corrupt downstream tables. Design the streaming pipeline.
Summary
Bad records cannot reach the warehouse.
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