Level 10 - MasterScenario-Based Questionsm5 architecture leadership decision rounds
Scenario: Legacy Pipeline Retirement Plan
A legacy ETL pipeline and a new streaming pipeline both feed executive dashboards with conflicting totals. Design retirement plan that preserves trust and avoids sudden data regressions.
Schema Context
etl_daily_metrics(d, revenue), streaming_metrics(d, revenue), dashboard_metrics(d, revenue)