Practice Test GeeksERP - Management Practice Test
← All ERP Flashcard Decks

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

  1. What is the purpose of maintaining a 'data migration log' throughout an ERP implementation?

    Answer: To record every migration run, errors encountered, and actions taken for audit and troubleshooting purposes

    A migration log provides a traceable record of each migration attempt, error, and resolution, supporting post-go-live troubleshooting and compliance audits.

  2. In ERP data migration, why is it critical to validate 'referential integrity' in the migrated data?

    Answer: To confirm that relationships between related records (e.g., invoices linked to customers) are intact

    Referential integrity ensures that foreign key relationships between tables (like an invoice pointing to a valid customer ID) are preserved, preventing orphaned records that break ERP processes.

  3. What is a 'cutover checklist' used for during ERP data migration?

    Answer: Ensuring every required migration step is completed in the correct sequence during the go-live weekend

    A cutover checklist provides a step-by-step, time-stamped task list executed during the live migration to ensure nothing is missed and to track progress against the plan.

  4. Which scenario BEST illustrates a 'data transformation' step in ERP migration?

    Answer: Converting a legacy date format (YYYYMMDD) to the ERP's required format (MM/DD/YYYY)

    Data transformation converts source data formats, structures, or values into the formats required by the target ERP system as part of the ETL process.

  5. Why might an organization choose NOT to migrate all historical transactions into a new ERP system?

    Answer: Migration of full history is too costly and time-consuming, and only opening balances are needed for operations

    Migrating years of full transaction history is expensive and often unnecessary; organizations typically migrate opening balances and archive detailed history for compliance access separately.

  6. What is the main reason ERP data migration projects frequently exceed their original budget?

    Answer: Data quality issues discovered during migration require unplanned cleansing effort

    Poor source data quality—with duplicates, missing values, and inconsistencies—is the most common cause of migration budget overruns because cleansing takes significantly more effort than anticipated.

  7. What is the purpose of a 'rollback plan' in ERP data migration?

    Answer: A documented process to revert to the legacy system if the migration fails at cutover

    A rollback plan defines the steps to restore the legacy system to operational status if critical issues prevent the new ERP from functioning correctly at go-live.