Six Sources, One Platform
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
- L5
Interview Prompt
Six source systems feed a new analytics platform: two emit events continuously, peaking at 5,000 per second combined, while four export nightly or weekly. About 40 finance analysts read the results through one BI tool. Design the end-to-end pipeline from the six sources to those finance dashboards.
Summary
ADF orchestrates. Unity Catalog governs. Nothing leaks.
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