The Dashboard and the Attribution Model
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
- L6
Interview Prompt
Design one architecture on Azure Databricks that feeds both a real-time campaign performance dashboard and a daily attribution report from a stream of ad impression and conversion events peaking near 200,000 per second. Today separate streaming and batch pipelines produce the two, and their numbers have drifted apart.
Summary
Streaming and batch. One pipeline to rule them.
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