Skip to interview prep
Apexed

81. A migration has the same row count before and after. What else would you validate?

MediumData & validation

Technical
Show model answer

Matching counts do not establish preserved values, relationships, completeness or permissions. Records can be duplicated and omitted in offsetting numbers, or mapped incorrectly while every count still looks correct to a reviewer who checks only the headline reconciliation total.

I'd check representative values, relationships, access and business invariants with owners. Acceptance needs preserved meaning and usable outcomes, not matching totals or an assumption that technical transfer guarantees equivalence.

What interviewers listen for

  • Check values relationships and exceptions
  • Test business meaning and access
  • Treat row counts as only one control
A migration has the same row count before and after. What else would you validate — Business analysis interview question — Apexed