Practice Test Geeks(ERP) Enterprise Resource Planning Certified Practice Test
← All ERP Flashcard Decks

Data Cleansing & Migration Strategy 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 Cleansing & Migration Strategy flashcards as text

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

    Answer: Error record count and resolution rate over time

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

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

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

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

  3. A referential integrity violation in ERP migration occurs when:

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

    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.

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

    Answer: Data Migration Acceptance Sign-off

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

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

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

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

  6. What is the role of a 'mapping specification' document in an ERP data migration?

    Answer: It documents field-level transformation rules from source to target

    A mapping specification is the authoritative record of how each source field is extracted, transformed, and loaded into the corresponding target ERP field.

  7. Which data quality dimension measures whether a value falls within an acceptable range or conforms to defined business rules?

    Answer: Validity

    Validity checks whether data values conform to defined formats, ranges, or reference lists (e.g., a valid country code or a positive invoice amount).