ERP Data Cleansing & Migration Strategy 2

Question 1

Which data profiling technique identifies the percentage of records with missing values in a field?

Accepted Answer

Completeness analysis

Answer

Completeness analysis measures what proportion of records have populated values for each field.

Question 2

During ERP migration, a 'delta load' refers to:

Accepted Answer

Migrating only records changed since the last extract

Answer

A delta load captures and migrates only the records that have been added or modified since the previous data extraction.

Question 3

What is the primary purpose of a data steward during an ERP migration project?

Accepted Answer

Owning accountability for data quality within a business domain

Answer

A data steward is a business-side role responsible for defining data rules, resolving quality issues, and ensuring domain data is fit for purpose.

Question 4

Which approach best reduces cutover risk when migrating a high-volume ERP general ledger?

Accepted Answer

Migrating only open balances and archiving history separately

Answer

Migrating open balances and archiving historical GL data reduces cutover window duration while preserving compliance access.

Question 5

A 'freeze period' in ERP migration is best described as:

Accepted Answer

A window where source system transactions are halted to create a stable migration snapshot

Answer

A freeze period halts or minimizes source system activity so that the extracted dataset is stable and consistent for final migration.

(ERP) Enterprise Resource Planning Certified Practice Test