ERP Data Migration 4 — Questions and Answers
Question 1: What is the primary risk of performing a data migration cutover on a Monday morning during business hours?
- Network bandwidth is lowest on Monday mornings
- Business activity is high and any issues immediately impact operations (Correct answer)
- ERP vendors provide less support on weekdays
- Data loads are slower during business hours
Correct 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.
Question 2: In ERP data migration, what is a 'mock cutover' or 'rehearsal migration'?
- A training exercise for end users on the new ERP interface
- A full end-to-end practice run of the cutover process before the actual go-live (Correct answer)
- A scaled-down pilot with only one department's data
- A vendor demonstration using sample data
Correct 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.
Question 3: Which data quality dimension refers to whether every required field in a migrated record contains a value?
- Accuracy
- Completeness (Correct answer)
- Consistency
- Timeliness
Correct answer: Completeness
Completeness measures whether all mandatory fields in the migrated records are populated, preventing null values from causing ERP processing failures.
Question 4: What is a 'go/no-go' decision in ERP data migration?
- A vendor decision about licensing terms
- A formal checkpoint to decide whether migration quality meets the threshold to proceed with cutover (Correct answer)
- A user vote on whether to adopt the new ERP
- An IT decision about server capacity
Correct 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.
Question 5: When migrating customer master data into an ERP, what is 'deduplication'?
- Removing deleted records from the source system
- Identifying and merging duplicate records to create a single, accurate customer record (Correct answer)
- Splitting one customer record into multiple accounts
- Encrypting customer personally identifiable information
Correct 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.
Question 6: What does 'data profiling' help a migration team understand before beginning an ERP data migration?
- Which employees need access to the new ERP
- The structure, quality, and patterns of data in the source system (Correct answer)
- How long the ETL scripts will take to run
- Which ERP modules to implement first
Correct 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.
Question 7: Which approach is BEST for handling confidential salary data during an ERP migration?
- Migrate it last to minimize exposure time
- Apply role-based access controls and encrypt the data both in transit and at rest (Correct answer)
- Store it in a separate spreadsheet until after go-live
- Allow only the IT team to view it during migration
Correct 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.
ERP Data Migration 4
What is the primary risk of performing a data migration cutover on a Monday morning during business hours?