Portfolio ↗

Quiz

2707 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 areas2707 Architecture Fundamentals81 Distributed Systems101 Data Architecture90 Cloud Architecture87 Networking86 API & Integration Architecture78 Reliability & Resilience88 Observability81 Performance & Capacity Engineering90 Security Architecture95 Cost Architecture & FinOps92 Business Architecture93 Architecture Communication91 Enterprise Architecture91 Legacy Modernization92 AI-Era Architecture96 Software Architecture & Engineering84 Architecture Patterns84 Architecture Decision-Making91 The Architect's Meta-Skills92 Delivery & Release Engineering93 Platform Engineering & Developer Experience92 Testing & Quality Architecture90 Data Platform Architecture98 Streaming & Real-Time Data93 Data Governance & Semantics91 Frontend & Experience Architecture91 Edge, Mobile & IoT88 Regulatory & Data Protection Architecture90 Assurance, Audit & Model Risk98
Difficulty Any beginner intermediate advanced

6 questions in Database Migration Under CD.

  1. Database Migration Under CD advanced

    A platform gates schema changes through a reviewable, revertible "deploy request" rather than allowing direct DDL. What does this buy, and what must the mechanism provide?

    2 min answer planetscalevitessschema-changegating
  2. Database Migration Under CD intermediate

    A release must rename a heavily used database column and ships tonight. The team proposes doing the rename in the deployment. What is wrong, and what do you propose?

    2 min answer migrationrollbackschemacontinuous-delivery
  3. Database Migration Under CD intermediate Multiple choice

    A superapp in the mould of Grab renames a column using expand and contract. The rolling deploy of the 240-pod service takes 11 minutes. A batch consumer reads a cached schema descriptor with a 1-hour TTL. A worker fleet is draining a 6-hour backlog of jobs serialised against the old shape. Mobile clients hold the old field name until users update. Roughly how long must both shapes stay correct before the contract step is safe?

    3 min answer grabexpand-and-contractschema-migrationmobile-clients
  4. Database Migration Under CD advanced

    A team deploys many times a day and must change the database schema. What discipline makes this safe?

    2 min answer migrationsexpand-contractrollbackbackfill
  5. Database Migration Under CD intermediate

    A team deploys several times a day and needs to change a database schema. What sequence prevents downtime, and which step is skipped?

    2 min answer chargebeemigrationexpand-contractbackfill
  6. Database Migration Under CD advanced Multiple choice

    You deploy at 14:00. At 14:20 error rates spike. The release included a migration that dropped a column. What do you do, and what should have been different?

    2 min answer rollbackmigrationincident