The section's 90/10 rule: ninety percent of silent failures are caught by ten percent of the possibl

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

The section's 90/10 rule: ninety percent of silent failures are caught by ten percent of the possible checks. The four cheap ones are row count (against a recent baseline), null rate (per column), uniqueness (on the primary key), and freshness (latest record vs current time). They run in seconds, need only basic SQL, and are explainable to a finance partner without a phone call. Pick row count, null, uniqueness, or freshness on the canvas: add four quality-check nodes between the transform and the mart, one per check, each named so the assertion and the threshold or baseline window are visible.

Practice This Problem

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