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. Row & Column-Level Security advanced

    Row-level security on the orders table restricts each regional analyst to their own region. An audit shows a Berlin analyst's dashboard returning French rows. The policy is present and correct on the table, the analyst's attributes are right, and the query in the dashboard selects from `orders_summary`. What happened?

    3 min answer rlsmaterialised-viewspolicy-bypassaudit
  2. Row & Column-Level Security advanced

    Salesforce's published Force.com design keeps many customers' records in shared tables described by metadata, rather than giving each tenant its own schema. Weissman and Bobrowski's SIGMOD 2009 paper describes the platform supporting tens of thousands of organisations this way. What does that choice force about access control, and where would copying it be a mistake?

    2 min answer salesforcemulti-tenancyrow-level securitymetadata
  3. Self-Service vs Governed intermediate

    A 90-person company has a data catalogue, a business glossary, a stewardship council meeting fortnightly, a dataset certification process and an access-request workflow with two approvers. Twelve people work with data. Review it — what would you remove, what would you change and what would you leave alone?

    3 min answer governanceover-engineeringself-serviceapprovals
  4. Self-Service vs Governed advanced

    A collaboration company wants every team to analyse data freely, and finance needs numbers that reconcile. How do you satisfy both?

    1 min answer self-servicegovernancetieringtrust
  5. Self-Service vs Governed intermediate

    A data team is asked to enable self-service analytics while ensuring numbers are trustworthy. How should the boundary be drawn?

    2 min answer amplitudeself-servicegovernancesemantic-layer
  6. Self-Service vs Governed intermediate

    How do you let analysts work freely without ending up with five conflicting versions of the same number?

    2 min answer self-servicetiersgovernancelabelling
  7. Semantic Layer intermediate

    A company adopts a central semantic layer so that "active customer" has one definition everywhere. Two years later analysts route around it. What did the organisation buy and what did it pay?

    2 min answer semantic layermetricsgovernancebottleneck
  8. Semantic Layer advanced

    A recommendation team maintains separate feature computation for offline training and online serving, and skew between them is degrading model quality. How does a feature store with point-in-time correctness fix this, and what does it cost operationally?

    3 min answer airbnbchrononfeature-storetraining-serving-skew
  9. Semantic Layer advanced

    Three teams report different numbers for the same metric and each is confident. What is the architectural cause, and what fixes it?

    2 min answer meeshosemantic-layermetricsdefinitions
  10. Semantic Layer advanced Multiple choice

    Where should shared metric definitions live so that a dashboard, a notebook and an API all produce the same number?

    1 min answer semantic-layermetricsconsistencygovernance
  11. Semantic Layer advanced

    You build a semantic layer with governed metric definitions. Six months later teams are still writing their own SQL. Why, and what do you do?

    2 min answer governanceadoptionmetrics
  12. Sensitivity Labelling intermediate

    A design platform holds user-generated content, customer brand assets and internal data in one estate. How should sensitivity labelling work so it is actually applied?

    1 min answer classificationlabellingautomationpolicy