1. 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
  2. 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
  3. 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
  4. 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
  5. Data Subject Rights intermediate

    A regulator asks how long after an erasure request the data is genuinely gone. Production deletes in seconds; backups are daily with 35-day retention; the warehouse is fed by change data capture; the search index rebuilds weekly; three processors hold copies. Roughly what number do you give and what does it rule out?

    2 min answer erasurebackupssuppression-listcdc
  6. Data Subject Rights advanced

    Design the architecture for handling access, correction and erasure requests across a large estate.

    1 min answer dsarerasurediscoveryorchestration
  7. Data Subject Rights intermediate

    You must let a customer download everything you hold about them in a machine-readable form, as Article 20 of the GDPR requires. The product holds profile data, 4 years of activity events, uploaded files, support conversations and model-derived scores. Design the export.

    3 min answer gdprportabilityexportaccount-takeover
  8. Data Subject Rights advanced

    You receive a subject access request. Legal says you have 30 days to produce everything you hold about this person. What does your architecture need to make that possible?

    2 min answer gdprprivacyarchitecture
  9. Data Subject Rights advanced

    Your organisation receives its first subject access request. Nobody knows where the person's data is. How do you respond within thirty days?

    2 min answer privacydsardiscoveryprocess
  10. Data Vault Modelling advanced

    A bank implemented Data Vault for auditability. Analysts say it is unusable and are extracting to spreadsheets. What went wrong?

    2 min answer modellingconsumptiongovernance
  11. Data Vault Modelling advanced

    A team proposes Data Vault for a customer domain. The source is one table of 40 columns, of which 6 are business or foreign keys and 34 are descriptive attributes changing at three clearly different rates. Before agreeing, estimate how many physical tables the vault produces, how many joins a plain "current customer with address and account status" query needs, and how many rows five years of history holds for 8 million customers. Which assumption dominates the error?

    3 min answer data vaultestimationsatellitesjoin depth
  12. Data Vault Modelling advanced

    An interviewer says - a regulator can ask us what any published report said on any date in the past two years and why it said that. Our platform already has a Data Vault. Where do you take this?

    3 min answer data-vaultreproducibilitybitemporalaudit