Portfolio ↗

Quiz

2707 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 areas2707 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 Architecture96 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 Architecture98 Streaming & Real-Time Data93 Data Governance & Semantics91 Frontend & Experience Architecture91 Edge, Mobile & IoT88 Regulatory & Data Protection Architecture90 Assurance, Audit & Model Risk98
Difficulty Any beginner intermediate advanced

50 questions in Data Governance & Semantics.

  1. BI Governance advanced Multiple choice

    At 09:10 an executive dashboard shows yesterday's conversion down 38%. By 09:40 every pipeline is confirmed healthy, row counts are normal and no schema changed. At 10:50 someone finds a pull request merged at 23:38 that changed the semantic layer's definition of a converted session. Fourteen experiments were mid-flight. Which design change most directly prevents a repeat?

    3 min answer bi-governancesemantic-layerexperimentationmetric-versioning
  2. BI Governance advanced

    Booking.com has described running more than 1,000 concurrent experiments in a 2017 paper on democratising experimentation. Before you let a thousand teams define their own metrics at that concurrency, what must be true of the semantic layer and the pipelines underneath?

    2 min answer bookingexperimentationsemantic-layermetric-governance
  3. Data Access Models advanced

    A data platform carries four years of accumulated standing grants: about 900 analysts in roughly 300 groups with permanent read on 6,000 tables. Legal now requires that purpose be recorded and access be time-boxed. You cannot stop analysts working for a day. Give the sequence.

    3 min answer access controljust-in-time accesspurpose limitationaudit
  4. Data Access Models advanced Multiple choice

    A file collaboration platform must decide how to model data access across personal files, shared folders, team spaces and external sharing. Which model fits?

    1 min answer authorisationrebacsharinggraph
  5. Data Access Models advanced

    Review this emergency data access design. A shared role called prod_break_glass grants read on every production table. Any team lead can approve a request in a chat channel. The grant has no expiry and is removed when someone remembers. Every use writes a row to an audit table in the same warehouse. It was used 140 times last year. What would you remove, what would you change, and what would you leave alone?

    3 min answer access-controlbreak-glassauditexpiry
  6. Data Catalog advanced

    A catalogue harvests column-level lineage by parsing the orchestrator's job definitions. A version upgrade changes one job format and the parser silently skips those jobs. The catalogue reports no error. What happens over the next three months?

    3 min answer lineagecatalogsilent failureimpact analysis
  7. Data Catalog advanced

    Salesforce's Force.com platform was described by Weissman and Bobrowski at SIGMOD 2009 as metadata-driven: many tenants' records share physical tables, with metadata rather than per-tenant schemas describing what each column holds. Your analytics estate sits on a platform of that shape. What breaks in a column-level data catalogue, and what replaces it?

    2 min answer salesforcemulti-tenancymetadatacatalogue
  8. Data Contracts advanced

    A data platform introduces data contracts and pipelines still break when producers change schemas. What was missing?

    2 min answer freshworksdata-contractsenforcementownership
  9. Data Contracts advanced

    A producer team renames a column. The data contract is defined and the contract test is green. Three hours later four downstream models fail and a board dashboard is blank. The test lived in the consumer's repository and ran on the consumer's schedule. What is the structural defect?

    3 min answer data contractscienforcement pointproducer
  10. Data Contracts advanced

    A schema change in one team's service breaks four downstream data consumers overnight. The contract existed. What failed?

    1 min answer data-contractsenforcementcicoupling
  11. Data Contracts advanced

    You propose data contracts. An application team says "we are not a data team, our database is our own business". How do you respond?

    2 min answer governanceownershipinfluence
  12. Data Governance & Semantics advanced Multiple choice

    A multi-tenant business application holds customer data for tens of thousands of organisations, each with its own compliance obligations. Which governance model actually works at that scale?

    1 min answer governancemulti-tenancypolicy-as-codedelegation