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. Data Sharing & Clean Rooms advanced

    Two companies want to analyse their combined data without either seeing the other's records. What makes that architecturally possible?

    2 min answer snowflakeclean-roomprivacyaggregation
  2. Data Sharing & Clean Rooms advanced Multiple choice

    Two companies want to measure advertising overlap without either seeing the other's user data. What architecture supports this?

    1 min answer clean-roomprivacydata-sharingaggregation
  3. Master Data Management advanced

    A large enterprise has customer records in a dozen systems with no shared identifier. Design the master data approach.

    1 min answer mdmentity-resolutionidentitydata-quality
  4. Master Data Management advanced

    A retailer sells the same stock through stores, its website and marketplaces. Stock counts disagree. What is the architecture problem?

    2 min answer walmartretailinventoryconsistency
  5. Master Data Management advanced

    Several systems each hold a version of the customer record and they disagree. What is the architectural approach?

    2 min answer ripplingmdmsystem-of-recordreconciliation
  6. Reference Data advanced

    A travel platform's currency, tax and geography reference data changes over time. Bookings must be reproducible years later. What does the reference data architecture need?

    1 min answer reference-dataversioningtemporalreproducibility
  7. Reference Data advanced

    Twilio's public Messages API documents a fixed set of message status values, and the initial value depends on how the message was created - accepted when a Messaging Service is used, queued when it is not. Every customer who writes an exhaustive match over that list inherits a dependency on it. What does publishing a code list as part of an API force on its owner, and where would copying that approach be a mistake?

    3 min answer twilioreference-datacode-listsapi-contracts
  8. Retention & Purge advanced

    A community platform implements a retention policy deleting user content after a defined period. What happens that nobody planned for?

    1 min answer retentiondeletionreferential-integritybackups
  9. Retention & Purge advanced

    An erasure request arrives for a customer whose data has propagated into a warehouse, a lake, search indexes, caches, backups and trained models. How is this handled, and what should have been designed in advance?

    2 min answer gdprerasurederived-datacrypto-shredding
  10. Retention & Purge advanced

    An insurance platform must delete data on request while retaining records for regulatory periods. What design satisfies both?

    2 min answer ackoretentionerasurelegal-hold
  11. Retention & Purge advanced Multiple choice

    On 5 April 2022 Atlassian ran a maintenance script to deactivate a legacy app. The script carried both a mark-for-deletion mode used in daily operations and a permanent-delete mode kept for compliance erasure. It ran in the wrong mode against site identifiers rather than app identifiers and destroyed 883 sites belonging to about 775 customers. Restoring them took up to two weeks. Which design change most directly prevents a repeat?

    2 min answer atlassianerasureblast radiussoft delete
  12. Retention & Purge advanced

    Your platform is built on an append-only event log with a lakehouse behind it. Legal asks how you will satisfy erasure requests within 30 days. What is your answer?

    2 min answer privacyerasurearchitecturecompliance