Portfolio ↗

Quiz

2627 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 areas2627 Architecture Fundamentals81 Distributed Systems101 Data Architecture90 Cloud Architecture77 Networking86 API & Integration Architecture78 Reliability & Resilience88 Observability81 Performance & Capacity Engineering90 Security Architecture85 Cost Architecture & FinOps82 Business Architecture93 Architecture Communication91 Enterprise Architecture91 Legacy Modernization82 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

60 questions in Data Architecture.

  1. CQRS advanced

    A consumer fintech team proposes CQRS because their read and write workloads are very different. What evidence should be required before accepting the added synchronisation, projection and operational complexity?

    2 min answer credcqrsprojectionscomplexity
  2. CQRS advanced

    A marketplace team proposes CQRS because search and browse read patterns differ sharply from the transactional write model. What evidence should be required before accepting the extra synchronisation and projection complexity?

    3 min answer cqrsread-modelsprojectionsetsy
  3. CQRS advanced

    A search index built by a projection has been serving wrong results for three weeks because of a bug in the projection logic. Walk through recovery.

    2 min answer cqrsprojectionsrebuildlinkedin
  4. Data Architecture advanced

    A B2B commerce platform aggregates inventory from many suppliers whose feeds arrive asynchronously with different frequencies and reliability. How should stale inventory, safety stock, reconciliation and supplier failures be handled?

    2 min answer udaanb2bsupplier-feedsstaleness
  5. Data Architecture advanced

    A feed-ranking system needs embeddings, counters and aggregates pushed from offline jobs to an online store at very high write throughput. How should such a derived-data serving system handle full rebuilds, incremental updates, versioning and reads during a swap?

    2 min answer linkedinvenicederived-datafeature-store
  6. Data Architecture advanced

    A multi-tenant SaaS product has outgrown one database. You must shard. How do you choose the partition key, and what makes this decision so expensive to get wrong?

    2 min answer shardingpartitioningmulti-tenancyscaling
  7. Data Architecture advanced

    Discord stores trillions of messages. What is their partition key, and what problem does the second half of it solve?

    2 min answer case-studydiscordpartitioninghot-partition
  8. Data Architecture advanced

    Netflix personalises an entire home page in the time a TV takes to draw a screen. How, given that scoring every title for every member on request is impossible?

    2 min answer case-studynetflixprecomputationcqrs
  9. Data Architecture advanced Multiple choice

    Uber indexes the world with hexagons rather than squares for surge pricing and dispatch. Why does the shape matter, and what is the general lesson?

    2 min answer case-studyubergeospatialindexing
  10. Data Governance advanced

    In a large enterprise, multiple teams write directly to the same core business tables and change schemas independently. What problems emerge, and what governance changes fix them without stopping delivery?

    3 min answer governanceownershipschema-changecoupling
  11. Data Lakes & Lakehouses advanced Multiple choice

    A recommendation platform stores petabytes of interaction events used for both ad-hoc analysis and model training, with occasional need to delete individual users' data. Which storage architecture fits, and why does the deletion requirement drive the choice?

    2 min answer lakehouseopen-table-formatsdeletiongdpr
  12. Data Lakes & Lakehouses advanced

    You are asked to choose between a cloud data warehouse and a lakehouse for a new analytics platform. How do you decide?

    2 min answer lakehousewarehouselock-indecision-making