The Bad Row That Broke the Dashboard
A medium Pipeline Design 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
- Pipeline Design
- Difficulty
- medium
- Seniority
- L6
Interview Prompt
The application event stream carries about 50,000 events per second at peak from 40 producer services, each publishing against a registered schema contract, and every event lands in Snowflake for analytics. Design the streaming pipeline that enforces those contracts at the source.
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
- Draw your pipeline on the design canvas: sources, transforms, storage and checks
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision