Sixty Minutes, Every Hour
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
- L6
Interview Prompt
The OLTP database behind our customer-facing app commits about 2 million row changes a day and already runs near its CPU limit, so the DBA who owns it will not accept any new reads. Design the pipeline that gets those changes into the analytics warehouse without loading the live database.
Summary
Every hour, on the hour. No excuses.
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