The Event Pile
A hard 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
- hard
- Seniority
- L7
Interview Prompt
Hundreds of millions of user interaction events a day land in Kafka, every one must stay queryable for two years, and today nothing can query them. Design the architecture that serves the analytics team's funnel studies, customer support's live session lookups and the product teams' last-hour dashboards from that one stream.
Summary
600 million clicks a day. The budget is not infinite.
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