1. Data Migration Strategies advanced

    A platform must migrate very large volumes of file data between storage systems. Which strategies apply, and what dominates the schedule?

    2 min answer data-migrationbulk-transferverificationcutover
  2. Data Migration Strategies advanced

    A shipping platform must migrate years of order and tracking data to a new store. What strategy handles both the historical bulk and the ongoing changes?

    2 min answer shiprocketdata-migrationcdcbackfill
  3. Data Migration Strategies advanced

    Month 1 of a migration, the reference tables for currency and tax class are copied to the new store and verified row for row. Month 9, a regulator forces a new tax class into the legacy system. Month 11, the new system starts rejecting about 1 order in 400 with a validation error nobody can reproduce in test. What failed, and which design decision made it possible?

    3 min answer reference datadriftcoexistencevalidation
  4. Data Migration Strategies advanced

    The source data contains records that violate the target's constraints. How do you handle it and who decides?

    2 min answer data-migrationqualityprofilingbusiness-decisions
  5. Data Observability intermediate

    A dashboard has shown the same numbers for eleven days. The pipeline reports success every night. What monitoring was missing?

    2 min answer monitoringqualityfreshness
  6. Data Observability intermediate

    A dashboard was wrong for three weeks before anyone noticed. What monitoring would have caught it?

    2 min answer nykaadata-observabilityfreshnessanomaly
  7. Data Observability advanced

    A data platform has thousands of datasets and cannot write manual quality tests for all of them. What should the observability approach be?

    1 min answer data-observabilityanomaly-detectionalertinglineage
  8. 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
  9. 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
  10. Data Platform Architecture advanced

    A mobility platform's data team is overwhelmed by requests and every new dataset requires their involvement. What is the structural problem?

    2 min answer data-platformself-serviceownershipbottleneck
  11. Data Platform Architecture advanced

    You are the first data platform engineer at a 200-person company. The CFO's board pack is assembled in a spreadsheet from three CSV exports, the product team queries a read replica directly, and two teams have started separate warehouse trials. Your manager asks what you will do in the first quarter. Walk me through how you would answer.

    2 min answer interviewplatformprioritisationstakeholders
  12. Data Platform Tenancy advanced

    A data platform serves many internal teams with very different data volumes and sensitivity. How should tenancy be structured?

    2 min answer data-tenancyisolationaccess-controlcost