Data Migration Flashcards
7 cards from real ERP practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Data Migration flashcards as text
What is the primary risk of performing a data migration cutover on a Monday morning during business hours?
Answer: Business activity is high and any issues immediately impact operations
Cutting over during peak business hours means any migration failures or data issues will immediately disrupt live business operations with no buffer time to resolve problems.
In ERP data migration, what is a 'mock cutover' or 'rehearsal migration'?
Answer: A full end-to-end practice run of the cutover process before the actual go-live
A mock cutover rehearses the complete migration process—including ETL, validation, and reconciliation—in a non-production environment to identify timing issues and risks.
Which data quality dimension refers to whether every required field in a migrated record contains a value?
Answer: Completeness
Completeness measures whether all mandatory fields in the migrated records are populated, preventing null values from causing ERP processing failures.
What is a 'go/no-go' decision in ERP data migration?
Answer: A formal checkpoint to decide whether migration quality meets the threshold to proceed with cutover
The go/no-go decision is a formal review where project leadership evaluates migration test results and data quality metrics to authorize or postpone the live cutover.
When migrating customer master data into an ERP, what is 'deduplication'?
Answer: Identifying and merging duplicate records to create a single, accurate customer record
Deduplication finds and consolidates duplicate customer records caused by multiple entries, name variations, or system mergers to ensure clean master data.
What does 'data profiling' help a migration team understand before beginning an ERP data migration?
Answer: The structure, quality, and patterns of data in the source system
Data profiling analyzes the source data to reveal quality issues, anomalies, and structural patterns that must be addressed before migration can proceed.
Which approach is BEST for handling confidential salary data during an ERP migration?
Answer: Apply role-based access controls and encrypt the data both in transit and at rest
Sensitive HR and payroll data must be protected with encryption in transit and at rest, combined with strict role-based access to comply with privacy regulations.