fct_orders runs cleanly today with no observability beyond the orchestrator's run status and no cost
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
fct_orders runs cleanly today with no observability beyond the orchestrator's run status and no cost visibility. The section's instrumentation sequence delivers value at each step: pillar coverage on the output (freshness, volume, schema, distribution checks in dbt tests), lineage visibility (push the dbt manifest plus BI query history to a shared catalog), cost tags (Snowflake QUERY_TAG with pipeline_id and run_id), then a runbook for the new alerts. Sequence the instrumentation by adding the four steps in order on the canvas, each with what it adds and the value it delivers before the next step starts.
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