ERP Data Cleansing & Migration Strategy 3

Question 1

Which metric is most useful for tracking data cleansing progress throughout an ERP migration project?

Accepted Answer

Error record count and resolution rate over time

Answer

Tracking how many error records exist and the rate at which they are being resolved shows whether cleansing efforts are effective and on schedule.

Question 2

Why is it important to migrate data to a 'sandbox' or 'unit test' ERP environment before the production cutover?

Accepted Answer

To validate transformation rules and surface data quality issues without impacting production

Answer

Sandbox migration runs expose mapping errors, missing data, and transformation defects in a risk-free environment before the irreversible production load.

Question 3

A referential integrity violation in ERP migration occurs when:

Accepted Answer

A foreign key value in the target has no matching primary key in its parent table

Answer

Referential integrity requires that every foreign key references an existing primary key; orphaned child records indicate the parent was not migrated or was mapped incorrectly.

Question 4

Which sign-off document formally confirms that business stakeholders accept migrated data as sufficient to operate the ERP go-live?

Accepted Answer

Data Migration Acceptance Sign-off

Answer

A Data Migration Acceptance Sign-off captures stakeholder approval that migration quality meets agreed thresholds and go-live can proceed.

Question 5

During ERP migration, 'data aging' refers to the risk that:

Accepted Answer

Data extracted early becomes stale and misaligned with source system by go-live

Answer

Data aging occurs when the gap between extraction and go-live is long, causing the migrated snapshot to diverge from current source reality.

(ERP) Enterprise Resource Planning Certified Practice Test

(ERP) Enterprise Resource Planning Certified Practice Test

ERP Data Cleansing & Migration Strategy 3