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