Portfolio ↗

Quiz

2868 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 areas2868 Architecture Fundamentals91 Distributed Systems101 Data Architecture90 Cloud Architecture87 Networking86 API & Integration Architecture87 Reliability & Resilience99 Observability92 Performance & Capacity Engineering90 Security Architecture95 Cost Architecture & FinOps92 Business Architecture93 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 Experience92 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

91 questions in Data Governance & Semantics.

  1. BI Governance intermediate Multiple choice

    A company certifies 400 of its 4000 dashboards with a badge an owner and a review at the moment the badge is granted. Eighteen months later an audit finds the certified set has the highest proportion of reports whose underlying model has changed since certification. Review the design. Which single change matters most?

    2 min answer bi governancecertificationstalenessattestation
  2. BI Governance intermediate

    A travel company has thousands of dashboards, several conflicting definitions of the same metric, and a large BI bill. Diagnose it.

    1 min answer bi-governancemetric-consistencysprawlcost
  3. 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
  4. 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
  5. BI Governance intermediate

    Two dashboards disagree about revenue. What mechanism would have prevented it, and what would not?

    2 min answer bi-governancesemantic-layercertificationdefinitions
  6. Business Glossary beginner

    A 60-person company is told it needs a business glossary. Twelve people work with data and there are about 25 terms that anyone argues about. A glossary tool costs a subscription and a week of setup. What does the tool buy over one spreadsheet with a named owner, and when does the spreadsheet win?

    3 min answer business-glossarypragmatismlinkagedrift
  7. Business Glossary intermediate

    A governance programme harvests 1,400 candidate business terms from dashboard titles and column comments and proposes to define and own all of them. Roughly how many terms can an organisation actually keep true, and what does that number change about the plan?

    3 min answer business glossarydefinitionsgovernance capacityreview cadence
  8. Business Glossary intermediate

    Finance, sales and product each define "active customer" differently, and all three are correct for their purpose. How should the glossary handle this?

    1 min answer glossarysemanticsdefinitionsgovernance
  9. Business Glossary intermediate

    Three dashboards report different numbers for "active users" and each is defensible. What is the actual problem, and what does a semantic layer have to provide to fix it?

    2 min answer semantic-layermetricsdefinitionsgovernance
  10. 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
  11. 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
  12. Data Access Models beginner Multiple choice

    A team masks national identity numbers inside each BI tool's data model so analysts see only the last four digits. Security asks them to move the masking into the warehouse instead. Why does the location of the rule matter more than the rule itself?

    2 min answer maskingaccess controlpolicy enforcementbi tools