Two pipelines on the canvas

A medium Pipeline Design interview practice problem on DataDriven. Write and execute real pipeline design code with instant grading.

Domain

Pipeline Design

Difficulty

medium

Problem

Two pipelines on the canvas. The first is an Airflow DAG of operators (extract, transform, load) with explicit task ordering and a cron schedule. The second is a Dagster software-defined-asset graph (raw_orders -> fct_orders -> revenue_dashboard_mart) with implicit ordering from the asset DAG and freshness policies driving the schedule. The section's framing: imperative answers 'what should run, in what order, when'; declarative answers 'what data assets should exist, derived from what other assets, and how fresh.' The right choice is workload fit, not tool preference. Pick declarative or imperative for each by adding a model-marker node whose name states the choice and the trade-off that drove it (mental model, schedule, backfill, cross-team boundaries).

Practice This Problem

Solve this Pipeline Design problem with real code execution. DataDriven runs your solution and grades it automatically.