The Clock That Runs Two Ways
A hard 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
- hard
- Seniority
- L5
Interview Prompt
Orders arrive on two clocks: a nightly extract from an on-premises transactional database and a real-time event stream from microservices, each under its own scheduler today. Both paths must land in one landing zone under one orchestration layer, with one SLA dashboard and one failure alert covering both.
Summary
Nightly batch and live events. One dashboard.
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