The day-one monitors cover freshness and volume but leave three blind spots
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
Interview Prompt
The day-one monitors cover freshness and volume but leave three blind spots. The section's framework adds schema (column added, dropped, retyped upstream), distribution (mean shift, null rate spike, new categorical value), and lineage (which downstream consumers does this break). Together the five pillars turn a single-pipeline view into a fleet-level view. Map signals to the five pillars by adding five monitor transforms on the curated table fct_orders, one per pillar, each with a tech that fits the pillar's check, and route the lineage pillar through a catalog node that captures column-to-column provenance.
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