The Living Table
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
Design the pipeline that loads our changing reference data into the new lakehouse every night: product catalog updates, customer profile changes and store-to-region assignments, which the source systems emit as change records stamped with who made each change and when. Finance's revenue reports and the compliance team's audits both read from it.
Summary
Data lands continuously. History must survive every update.
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