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

35 questions in Data Governance & Semantics.

  1. Data Observability intermediate Multiple choice

    A grocery marketplace of the kind Instacart operates ingests retailer inventory feeds hourly and deduplicates on store id plus SKU. A retailer changes its SKU format and about 3% of distinct products now collide, so rows silently merge. Ingested row counts fall 3%, inside the 20% anomaly band. Schema tests pass and availability on the storefront quietly degrades. Which single check catches this?

    3 min answer instacartdata-observabilityreconciliationsilent-failure
  2. Data Observability intermediate

    A quarterly board report shows a category down 40%. Investigation finds an upstream system stopped sending a field three months ago. Nothing alerted. What do you change?

    2 min answer observabilityqualitycontractsincidents
  3. Data Products intermediate

    A marketplace publishes a merchant sales data product with a 15-minute freshness SLO to roughly 200000 merchant consumers. A flash sale of the kind Flipkart runs takes order volume to about 20 times normal for six hours. No pipeline fails and no alert fires. What happens to the data product over those six hours and what stops it?

    3 min answer data productsfreshness slopeak loaddegradation
  4. Data Products intermediate

    A ride-hailing and delivery platform operating across eight South-East Asian markets, of the kind Grab operates, has one internal trips_enriched table that 40 teams already read directly. Leadership wants it published as a data product with an owner, a freshness SLO and per-market residency rules. You cannot break the 40 readers and there is no cutover weekend available. Give the sequence.

    3 min answer grabdata-productsresidencyconsumer-migration
  5. Data Products intermediate

    A team's dataset is heavily used, so the platform group proposes promoting it to a data product with an owner, a published interface and an SLO. The team is willing. What have they actually taken on, and when does that bill arrive?

    2 min answer data-productsownershipslodeprecation
  6. Data Quality Dimensions intermediate Multiple choice

    A nightly freshness check alerts when a table's daily row count deviates more than 20% from the previous day. Volume follows a weekly pattern: weekends run about 40% below weekdays. Roughly how many alerts a month does this produce before anything is actually wrong, and what should replace it?

    2 min answer data-qualityalertingseasonalitythresholds
  7. Data Quality Dimensions intermediate

    A team wants to measure data quality. Which dimensions matter, and which tests actually catch problems?

    2 min answer dbt-labsdata-qualitytestsfreshness
  8. Data Quality Dimensions intermediate

    You are setting data quality thresholds for a dataset with five consuming teams. How do you decide the numbers?

    1 min answer data-qualitygovernancesla
  9. Data Stewardship intermediate

    A newsroom's data stewardship programme has stewards named for every dataset and almost no stewardship happening. What would you change?

    1 min answer stewardshipownershipincentivesoperating-model
  10. Data Stewardship intermediate

    After a year of stewards in name only, a company funds the role properly: 18 stewards at 20% of their time, written into objectives, with authority to refuse an access request. Two quarters later definitions are current and the analytics team is complaining loudly. What did the organisation buy, what is it paying, and when does that bill arrive?

    2 min answer data stewardshipdecision rightsaccess requestsqueue time
  11. Data Stewardship intermediate

    Review this stewardship design. Every one of 1,200 tables has a named steward drawn from the business. Stewards approve access requests, maintain descriptions in the catalogue and attend a monthly forum. After a year, 30% of descriptions are filled in, access approvals take nine days and the forum has six regular attendees. What would you change and what would you keep?

    2 min answer stewardshipgovernanceoperating-modelincentives
  12. Master Data Management intermediate

    An insurer has three customer masters: one in the policy system, one in claims, one in the broker portal. Each is authoritative for something. Leadership wants one. Give the sequence that gets there without a cutover weekend.

    2 min answer mdmgolden recordcoexistencemigration