Data migrations require precise technical language. Practise the collocations database engineers use when planning and executing schema and data migrations.
0 / 5 completed
1 / 5
Fill in: 'The database team will ___ the migration during the maintenance window on Saturday night.'
We 'run a migration' — 'run' is the standard engineering collocation for executing a database migration script or tool. 'Execute a migration' is also correct and formal; 'perform a migration' is acceptable; 'do a migration' is informal and imprecise.
2 / 5
Fill in: 'We need to ___ the user_preferences column for all 50 million existing rows after adding it.'
We 'backfill data' — 'backfill' is the database-migration collocation for retroactively populating a new column or table with historical data. 'Populate' is acceptable but broader; 'fill' is informal; 'update' is correct SQL but 'backfill' is the specific migration collocation.
3 / 5
Fill in: 'Before running the migration, we must ___ the target schema against the production baseline.'
We 'validate a schema' — 'validate' is the data-engineering collocation for systematically checking that a schema meets specified requirements. 'Check' is informal; 'verify' is used for test outcomes; 'confirm' implies agreement from a person rather than an automated check.
4 / 5
Fill in: 'After a week of parallel running, we will ___ to the new system next Friday.'
We 'cut over to the new system' — 'cut over' is the data-migration collocation for the moment when traffic or operations are switched from the old to the new system. 'Switch' is informal; 'move' is too vague; 'migrate' refers to the data process, not the final transition moment.
5 / 5
Fill in: 'If validation fails after the cut-over, we have a plan to ___ the migration within 15 minutes.'
We 'roll back a migration' — 'roll back' is the standard DevOps and database collocation for returning to the previous state after a failed change. 'Undo' and 'revert' are used for code changes in version control; 'cancel' applies to pending operations, not completed migrations.