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. Data Stewardship beginner Multiple choice

    A 40-person company has three different numbers for "completed order" living in three spreadsheets. Twelve people touch data at all. A consultant has proposed a governance programme. Which arrangement fixes the problem with the least machinery?

    3 min answer stewardshipgovernancepragmatismenforcement
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  11. Reference Data intermediate

    A reference data set of branch codes is maintained by an operations team. A branch closes in March and its code is retired. In September the code is assigned to a new branch in another city. Six months later finance asks why one branch's historical performance looks impossible. What happens across the estate?

    2 min answer reference-dataidentifiershistoryjoins
  12. 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