1. 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
  2. Data Residency advanced

    A client says "our data must stay in country". What do you ask before designing anything?

    2 min answer residencycompliancerequirements
  3. Data Residency advanced

    A communications platform must keep customer data in-region for several markets. What does that actually require?

    1 min answer residencyregional-isolationroutingmetadata
  4. Data Residency advanced

    A delivery marketplace of Swiggy's shape serves five countries from two regions. Its India payments partner points at the Reserve Bank of India's directive of 6 April 2018 requiring payment system data to be stored only in India. Finance asks what a dedicated in-India cell would cost annually before the partnership is signed. Work the number and say what it rules out.

    3 min answer data-residencyrbicell-based-architectureunit-economics
  5. Data Residency advanced

    A global payroll platform must keep certain data within specific jurisdictions. What does that force into the architecture?

    2 min answer deelremoteresidencyregional
  6. Data Residency advanced

    A product must keep certain customers' data within specific jurisdictions. What are the architectural options, and which parts are hardest?

    3 min answer residencysovereigntypartitioningmulti-region
  7. Data Residency advanced

    An e-commerce group of Flipkart's shape runs an in-India cell for regulated payment data and an EU cell for everything else. A quarterly control test samples 500 rows from the EU warehouse and finds 38 carrying Indian cardholder identifiers. The routing layer is correct and the replication topology is correct. Where do you look and in what order?

    3 min answer data-residencytelemetry-leakagedata-classificationegress-control
  8. Data Residency advanced

    Six weeks before launch, legal confirms that customer data for one market must be processed and stored in-country. The architecture is single-region in another jurisdiction. What do you do?

    3 min answer residencyregulatoryarchitecturemigration
  9. Data Sharing & Clean Rooms advanced Multiple choice

    A retailer wants to measure whether a brand's advertising drove in-store purchases. The brand has exposure data with hashed identifiers and the retailer has transactions. Neither may see the other's raw records. Which arrangement should they use?

    2 min answer clean roomprivacyaggregation thresholddifferential privacy
  10. Data Sharing & Clean Rooms advanced

    A retailer with 40 million loyalty members and a brand with 12 million exposed device identifiers want to measure in-store purchase lift inside a clean room. Hashed-email match comes back at about 23%. The four-week category purchase rate is around 2%. Roughly what relative lift can this measurement detect, and what does the number rule out?

    3 min answer clean-roomsmatch-ratestatistical-powermeasurement
  11. 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
  12. 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