Question 7 of 10Pro Only

During a database migration, you discover data inconsistencies between the source and target. Some data appears to be missing on the target. How do you investigate, quantify, and resolve this issue while the migration is in progress?

Sample answer preview

Discovering data inconsistencies during migration is a serious situation that requires immediate, methodical investigation. Panic-driven responses like restarting the entire migration can make things worse.

data validationrow count comparisonCDC gapLOB migrationchecksum comparisonDMS validation

Unlock the full answer

Get the complete model answer, key points, common pitfalls, and access to 9+ more Database Administrator interview questions.

Upgrade to Pro

Starting at $19/month • Cancel anytime