Six Sources, One Platform
A medium Pipeline Design mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- Pipeline Design
- Difficulty
- medium
- Seniority
- L5
Interview Prompt
We're building a greenfield analytics platform. We have six source systems that need to be ingested on very different schedules and have different governance requirements: finance teams need access to the data without seeing customer PII, and when a finance dashboard number is questioned, the platform team has to be able to point to the source records that produced it. Design the end-to-end pipeline architecture: how each source flows in, how the warehouse exposes the right views to each team, and how lineage is captured.
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
- Write your pipeline design solution with real code execution
- Get instant feedback and a hire/no-hire decision