1. Materialized Views advanced

    A read-heavy query is too expensive to compute on demand. Compare a database materialized view, an application-maintained read model and a stream-processed view, and describe how each handles staleness and rebuild.

    2 min answer materialized-viewscqrsread-modelstaleness
  2. Materialized Views advanced

    A ride-hailing platform maintains a materialised view of driver availability by geographic cell. What are the design decisions, and what breaks?

    2 min answer olamaterialized-viewfreshnessprojection
  3. Materialized Views advanced

    Your social feed precomputes each user's timeline when someone they follow posts. An account with 40 million followers joins. What breaks and how do you fix it?

    2 min answer feedfanouthybridscale
  4. Orchestration vs Choreography advanced

    A multi-step business process spans several services. When should it be orchestrated by a coordinator and when choreographed through events, and how do you tell which one you already have?

    2 min answer orchestrationchoreographysagatemporal
  5. Orchestration vs Choreography advanced

    A workflow spans eight services using event choreography. Nobody can answer "where is order 41,229 stuck?". What do you change?

    2 min answer orchestrationchoreographyworkflowobservability
  6. Orchestration vs Choreography advanced

    A workflow spans several services. What is the practical rule for choosing orchestration or choreography, and what is the design tell?

    2 min answer orchestrationchoreographyobligationsnotifications
  7. Orchestration vs Choreography advanced

    An interviewer says - we run order fulfilment across six services with events and no coordinator. Last quarter about 0.4% of orders ended in a state nobody noticed for days. Do not tell me to add tracing. What structural change do you make, and who gets paged?

    3 min answer choreographyprocess managerownershipon-call
  8. Orchestration vs Choreography advanced

    An order flows through payment, restaurant acceptance, courier assignment and delivery. Should the coordination be orchestrated or choreographed?

    2 min answer swiggyorchestrationchoreographysaga
  9. Outbox advanced

    A financial platform needs state changes to reliably produce events. When is the transactional outbox the right choice and when is change data capture better?

    2 min answer brexoutboxcdcevents
  10. Outbox advanced

    A service must update its database and publish an event, and both must happen or neither. Why is a dual write wrong, and how do the outbox pattern and log-based capture compare?

    3 min answer outboxcdcdual-writeatomicity
  11. Outbox advanced

    Orders are occasionally created in the database with no corresponding event reaching the warehouse. No errors are logged. Diagnose and fix.

    3 min answer outboxdual-writeconsistencyevents
  12. Publish/Subscribe advanced

    A chat platform uses publish/subscribe to deliver messages to connected clients. What breaks when a channel has a million members, and what changes?

    2 min answer pubsubfan-outscalepresence