Portfolio ↗

Quiz

2908 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 areas2908 Architecture Fundamentals91 Distributed Systems101 Data Architecture90 Cloud Architecture87 Networking86 API & Integration Architecture87 Reliability & Resilience99 Observability92 Performance & Capacity Engineering100 Security Architecture95 Cost Architecture & FinOps102 Business Architecture103 Architecture Communication102 Enterprise Architecture100 Legacy Modernization92 AI-Era Architecture96 Software Architecture & Engineering93 Architecture Patterns94 Architecture Decision-Making101 The Architect's Meta-Skills102 Delivery & Release Engineering103 Platform Engineering & Developer Experience102 Testing & Quality Architecture102 Data Platform Architecture98 Streaming & Real-Time Data103 Data Governance & Semantics91 Frontend & Experience Architecture101 Edge, Mobile & IoT98 Regulatory & Data Protection Architecture99 Assurance, Audit & Model Risk98
Difficulty Any beginner intermediate advanced

5 questions in Data Vault Modelling.

  1. Data Vault Modelling advanced

    A bank implemented Data Vault for auditability. Analysts say it is unusable and are extracting to spreadsheets. What went wrong?

    2 min answer modellingconsumptiongovernance
  2. Data Vault Modelling advanced

    A team proposes Data Vault for a customer domain. The source is one table of 40 columns, of which 6 are business or foreign keys and 34 are descriptive attributes changing at three clearly different rates. Before agreeing, estimate how many physical tables the vault produces, how many joins a plain "current customer with address and account status" query needs, and how many rows five years of history holds for 8 million customers. Which assumption dominates the error?

    3 min answer data vaultestimationsatellitesjoin depth
  3. Data Vault Modelling advanced

    An interviewer says - a regulator can ask us what any published report said on any date in the past two years and why it said that. Our platform already has a Data Vault. Where do you take this?

    3 min answer data-vaultreproducibilitybitemporalaudit
  4. 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
  5. Data Vault Modelling advanced

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

    2 min answer data-vaultauditabilityintegrationcomplexity