The Analyst Who Saw the Salary Data
A hard 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
- hard
- Seniority
- L5
Interview Prompt
We operate a multi-tenant data lake used by five different business units, each with different data sensitivity levels and compliance requirements. Currently all data is stored in a flat structure with a single shared reader role. We have had two incidents where engineers accessed data from a different business unit. Design a file-level access control architecture for the data lake.
Summary
Two incidents. One shared lake. The access model was never designed, just assumed.
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