Portfolio ↗

Quiz

2667 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 areas2667 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 Architecture86 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 Architecture88 Streaming & Real-Time Data93 Data Governance & Semantics81 Frontend & Experience Architecture91 Edge, Mobile & IoT88 Regulatory & Data Protection Architecture90 Assurance, Audit & Model Risk88
Difficulty Any beginner intermediate advanced

90 questions in Data Architecture.

  1. Streaming Data advanced

    A live-streaming platform must compute real-time viewer counts, chat rate and moderation signals during events where concurrent viewers spike tenfold within minutes. What streaming architecture handles this, and what happens if the stream processor falls behind?

    3 min answer streamingwindowinglive-eventstwitch
  2. Streaming Data advanced

    A streaming aggregation reports lower totals than the batch job it replaced. Both read the same source. What is likely happening?

    2 min answer streamingwatermarkslate-dataevent-time
  3. Streaming Data advanced Multiple choice

    A streaming aggregation stops emitting results. The job is healthy, consuming messages and using CPU. What is the most likely cause?

    2 min answer streamingwatermarkswindowingdoordash
  4. Transactions & Isolation advanced

    A fashion marketplace lets sellers update inventory while customers are checking out. How should reservations, optimistic concurrency, expiry, retries and failed payments interact to prevent overselling?

    2 min answer myntraoversellreservationoptimistic-concurrency
  5. Transactions & Isolation advanced

    A financial application runs at read-committed isolation. Two concurrent transactions each read an account balance, check it is sufficient, and debit it. Both succeed and the account goes negative. What happened, and which fixes are correct?

    2 min answer isolationlost-updateserialisabilitylocking
  6. Transactions & Isolation advanced

    A rule requires at least one engineer on call. Two engineers simultaneously remove themselves; both transactions check the rule, both pass, both commit. Nobody is on call. Name the anomaly and three fixes.

    2 min answer isolationwrite-skewserializableconcurrency