An operational SLA states 'fresh by 6am'; a quality SLA states 'correct row counts and null rates by
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
An operational SLA states 'fresh by 6am'; a quality SLA states 'correct row counts and null rates by 6am.' The two are independent: a pipeline can meet 6am with a 30 percent row-count drop, or have flawless data and miss 6am. Status pages that report a single number describe operational SLA exclusively, leaving consumers unable to distinguish 'late but correct' from 'on time but wrong.' Split the SLAs by adding two separate monitoring paths off the curated table, one whose name states the operational SLA target and the orchestrator metric it reads, and one whose name states the quality SLA target and the gates it depends on. Each path routes to its own paging destination.
Practice This Problem
Solve this Pipeline Design problem with real code execution. DataDriven runs your solution and grades it automatically.