Portfolio ↗

Quiz

2948 questions of the kind that actually get asked — in interviews, in architecture review boards, and by the person who has to run the thing at 3 AM. Every answer states the trade-off rather than the slogan, and says when the obvious choice is the wrong one.

All areas2948 Architecture Fundamentals91 Distributed Systems101 Data Architecture90 Cloud Architecture87 Networking96 API & Integration Architecture87 Reliability & Resilience99 Observability92 Performance & Capacity Engineering100 Security Architecture105 Cost Architecture & FinOps102 Business Architecture103 Architecture Communication102 Enterprise Architecture100 Legacy Modernization102 AI-Era Architecture106 Software Architecture & Engineering93 Architecture Patterns94 Architecture Decision-Making101 The Architect's Meta-Skills102 Delivery & Release Engineering103 Platform Engineering & Developer Experience102 Testing & Quality Architecture102 Data Platform Architecture98 Streaming & Real-Time Data103 Data Governance & Semantics91 Frontend & Experience Architecture101 Edge, Mobile & IoT98 Regulatory & Data Protection Architecture99 Assurance, Audit & Model Risk98
Difficulty Any beginner intermediate advanced

5 questions in Database Migration.

  1. 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
  2. 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
  3. 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
  4. Database Migration advanced

    Notion sharded its Postgres data into 480 logical shards across 32 physical databases in 2021 and then in 2023 spread the same 480 logical shards across 96 databases, with no change to the routing logic. What did the 2021 decision buy, what did the 2023 move still cost, and where would copying the number be a mistake?

    3 min answer notionpostgresshardingresharding
  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