1. Relational Modelling intermediate

    A team proposes storing the customer's address on every order row "so order history is accurate". Is that denormalisation or a modelling error?

    2 min answer normalisationmodellinghistorytemporal
  2. Relational Modelling intermediate

    A team wants to store a product's variable attributes as a JSON column rather than modelling them as tables. When is that right and what is given up?

    2 min answer relationaljsonschemamodelling
  3. Capacity Planning intermediate

    A service runs across three availability zones at 70% CPU during peak. The team wants to survive losing one zone at peak with no user impact. Roughly what does that require, and what does the same arithmetic say about running across two zones?

    3 min answer capacityheadroomavailability zonesstatic stability
  4. Reliability Culture intermediate

    An organisation adopts blameless postmortems but engineers still avoid admitting mistakes and incidents are under-reported. What is missing beyond the stated policy?

    2 min answer cultureblamelesspsychological-safetyincentives
  5. Reliability & Resilience intermediate

    A team is launching a new service and asks what its SLO should be. How do you help them decide, and why is "99.99%" usually the wrong first answer?

    2 min answer slosreerror-budgetreliability
  6. Reliability & Resilience intermediate

    The business asks for "100% uptime" for a new customer portal. Walk me through the conversation that ends in an agreed SLO.

    3 min answer slisloslanegotiation
  7. Rendering Strategies intermediate

    A marketing site is a client-rendered single-page application. Organic traffic is poor and the team blames the search engine. What is your assessment?

    1 min answer frontendrenderingseoperformance
  8. Rendering Strategies intermediate

    A team must choose between static generation, incremental regeneration, server rendering and client rendering for different parts of a product. What decides each, and what is the common mistake?

    2 min answer ssrssgisrcsr
  9. Replatforming intermediate

    A marketplace replatforms a service from a self-managed database to a managed one. What benefits are real, what constraints appear, and what must be verified first?

    2 min answer replatformmanaged-servicesconstraintsmigration
  10. Replatforming intermediate

    A team replatforms a self-managed database onto a managed service in six weeks and the project lands on time. Eighteen months later they are running an unplanned major-version upgrade over a weekend because the provider's standard support for their engine version ends. What did the replatform actually trade away, and when does that bill arrive?

    3 min answer replatformmanaged servicesupgradesend of support
  11. Replication intermediate

    A marketplace seller edits a listing and is immediately shown the old version, because the read went to a replica. What are the options, and how should the choice be made?

    2 min answer replicationread-your-writesconsistencyebay
  12. Replication intermediate

    An analytics platform's database is write-bound rather than read-bound. The team adds read replicas and nothing improves. Why, and what should be done instead?

    2 min answer posthogwrite-boundreplicasingestion