# The platform team is doing a year-end pass on a representative pipeline

Canonical URL: <https://datadriven.io/problems/the-platform-team-is-doing-a-year-end-pass-on-a-representati-df57e4f0>

Domain: Pipeline Design · Difficulty: medium

## Problem

The platform team is doing a year-end pass on a representative pipeline. Compose the operational state. Five-pillar coverage on the curated table; lineage catalog with column-level provenance; query tags with a cost rollup; slim-CI with the four test layers; environment data shapes (sample dev, slim-CI subset, masked staging, prod) with PII hashing; declarative-vs-imperative choice named on each pipeline; ownership audit with quarterly cadence; five-phase deprecation in place; cost rhythm with the five levers and an accountability owner. Show one representative pipeline on the canvas with every piece wired so the program is reproducible across the rest.

## Related

- [All practice problems](https://datadriven.io/problems)
- [Mock interview mode](https://datadriven.io/interview/the-platform-team-is-doing-a-year-end-pass-on-a-representati-df57e4f0)
- [System Design Interview Questions](https://datadriven.io/data-engineering-system-design)
- [Data Engineering Interview Prep Guide](https://datadriven.io/data-engineer-interview-prep)
- [Daily Challenge](https://datadriven.io/daily)

---

Source: DataDriven (https://datadriven.io). 100% free data engineering interview prep. Live code execution against Postgres 16, Python 3.11, and Spark sandboxes. No paywall, no premium tier, no signup gate.