1. Data Migration Strategies advanced

    The source data contains records that violate the target's constraints. How do you handle it and who decides?

    2 min answer data-migrationqualityprofilingbusiness-decisions
  2. Database Migration advanced

    A billing platform is extracting services from a shared database. Should the code be split first or the data?

    2 min answer chargebeedecompositiondatabaseownership
  3. Database Migration advanced

    A product must move its primary data store while remaining live, with no acceptable data loss. What is the migration sequence, and where do these go wrong?

    2 min answer database-migrationdual-writeverificationcutover
  4. Database Migration advanced

    An online schema change is needed on a billion-row MySQL table with zero downtime. Compare trigger-based, binlog-based and native approaches, and describe how the change is gated and reverted.

    3 min answer schema-changegh-ostpt-online-schema-changemysql
  5. Database Migration advanced

    Walk through migrating a live database to a different engine with no downtime. Where does reversibility end?

    2 min answer migrationverificationshadow-readsreversibility
  6. Decommissioning advanced Multiple choice

    A replaced system was made read-only for 30 days. No complaints came in and it was switched off, with its data exported to an archive. Three weeks later the annual regulatory extract fails, because the job read directly from the retired database. Which design decision made this possible?

    3 min answer decommissioningbatchregulatoryobservability
  7. Legacy Assessment advanced

    A twenty-year-old core system supports most of the business. It is on unsupported technology, three people understand it, and the last replacement attempt was abandoned after two years. Design the programme.

    3 min answer legacystranglerriskbusiness-case
  8. Legacy Integration Patterns advanced

    A new platform must integrate with legacy systems that only support batch file exchange. How should the boundary be designed so the new system is not constrained by it?

    2 min answer elasticrunlegacybatchanti-corruption
  9. Legacy Modernization advanced

    A 15-year-old monolith runs the core of the business. Leadership wants microservices. How do you approach it, and what would make you refuse?

    2 min answer stranglermodernizationmicroservicesrisk
  10. Legacy Modernization advanced

    Most large modernisation programmes are late, over budget, or abandoned. What are the recurring structural causes, rather than the project-management ones?

    2 min answer modernisationsecond-systemcoexistencescope
  11. Legacy Modernization advanced

    TSB's 2018 core banking migration moved 1.9 million customers in a single weekend and failed publicly. What would you have required before approving that cutover?

    3 min answer migrationcutovertestingcase-study
  12. Mainframe Modernization advanced

    A core system is reliable, undocumented and staffed by people close to retirement. What do you do first?

    2 min answer mainframeencapsulationstranglerskills