Portfolio ↗

Quiz

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

2777 questions.

  1. Data Vault Modelling advanced

    Review this estate. Postgres and three SaaS sources land raw in bronze. A Data Vault of hubs, links and satellites is built in silver. Star schemas are built in gold. Six departmental extracts are then copied into departmental warehouses. Freshness is 40 minutes, the team is six people, and there are 42 dashboards. What would you remove, what would you change, and what would you leave alone?

    2 min answer data-vaultlayeringover-engineeringreview
  2. Data Vault Modelling advanced

    What problem does data vault modelling solve, and when is its complexity justified?

    2 min answer data-vaultauditabilityintegrationcomplexity
  3. Data Virtualisation advanced

    A BI tool queries the operational read replica directly through a federation layer, avoiding a copy. At 09:03 replica lag starts climbing. By 09:12 checkout p99 has tripled. By 09:30 the replica is 40 minutes behind and support is reporting stale order status. What failed, and which design decision allowed it?

    3 min answer federationreplicaspushdownlag
  4. Data Virtualisation intermediate

    A federation layer serves 60 analysts across four sources: the lakehouse, a Postgres replica, a managed warehouse and a SaaS REST connector. At 11:40 the REST connector's upstream begins answering in 40 seconds rather than 200 ms. Nothing errors and nothing is down. Walk through what happens to the other analysts over the next ten minutes.

    3 min answer federationhead-of-line blockingbulkheadsconcurrency
  5. Data Virtualisation intermediate

    A group holds customer data in separate EU and US entities, and the rows may not be copied across the border. The board wants one revenue dashboard. The team puts a federation layer over both regions and queries in place rather than consolidating. What has that bought, when does the bill arrive, and how do they keep the option to reverse it?

    2 min answer federationresidencypushdowncross-region
  6. Data Virtualisation intermediate

    A platform proposes querying operational databases directly rather than copying data. When does that work?

    2 min answer virtualisationfederationcouplingload
  7. Data Virtualisation advanced

    A vendor proposes replacing your ingestion pipelines with data virtualisation — query everything in place, no copies. Assess it.

    1 min answer federationarchitectureevaluation
  8. Data Warehousing advanced

    A finance report double-counts revenue after a new fact table is added. What is the likely modelling error?

    2 min answer warehousegrainfan-outdimensional-modelling
  9. Data Warehousing advanced

    A travel platform runs thousands of experiments simultaneously and needs its warehouse to support reliable analysis. What warehouse design decisions prevent cross-experiment contamination and infrastructure artefacts from being read as results?

    2 min answer warehouseexperimentationdata-modellingbooking
  10. Data Warehousing intermediate

    An analytics platform separates compute from storage. What does that actually buy architecturally, and what problems does it not solve?

    2 min answer snowflakecompute-storageisolationconcurrency
  11. Data Warehousing intermediate

    Finance and marketing report different revenue for the same month from the same warehouse. Where do you look and what would have prevented it?

    2 min answer warehouseconformed-dimensionsdefinitionswalmart
  12. Database Migration advanced

    A billing platform is extracting services from a shared database. Should the code be split first or the data?

    2 min answer chargebeedecompositiondatabaseownership