Capstone Gold: Architecture and Migration
Objective:
Design a migration from a legacy mixed-grain model to a governed serving architecture.
Deliverables:
- Recommend architecture (star, vault+mart, or hybrid) with tradeoff reasoning.
- Define phased migration plan (shadow, pilot, cutover).
- Include KPI regression strategy, backfill strategy, and rollback criteria.
Architecture Challenge Drill #
Loading SQL editor...
Grading Rubric #
- 35% Architecture decision quality and tradeoff reasoning
- 25% Migration sequencing and risk control
- 20% KPI regression and reconciliation strategy
- 20% Operational resilience (backfill, rollback, ownership)
Warning
Gold-level work must show engineering judgment under uncertainty, not only technically correct SQL.