Near-Real-Time Trending Dishes Dashboard
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
- L5
Interview Prompt
Design the data pipeline behind a dashboard that shows restaurant partners on our food delivery platform which dishes are trending in their city, judged on each dish's order rate over the last 30 minutes. The partner team plans for about 2 million orders a day across 300 cities, peaking near 500 orders per second at dinner.
Summary
The dish rankings update faster than the kitchen.
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