CIS Data Migration & Integration Flashcards

Which type of testing validates that data moved during a CIS migration is complete, accurate, and consistent in the target system?

Answer: Data validation testing

Data validation testing specifically checks migrated records for completeness, accuracy, referential integrity, and consistency in the target system.

A 'rollback plan' in CIS data migration is critical because:

Answer: It provides a tested path to restore the legacy system if the migration fails

A rollback plan defines the exact steps to revert to the legacy system if critical failures occur during cutover, minimizing business disruption.

What is the primary risk of a 'Big Bang' data migration approach in a CIS implementation?

Answer: All data is migrated at once, creating a single large high-risk cutover event

Big Bang migration moves all data in one event, which concentrates risk into a single cutover window and leaves little room for error recovery.

In CIS integration architecture, a webhook differs from a REST API polling approach in that:

Answer: Webhooks push data to the consumer automatically when an event occurs

A webhook automatically pushes data to a predefined URL when a triggering event occurs, eliminating the need for the consumer to repeatedly poll for updates.

What is the significance of a 'freeze period' immediately before a CIS data migration cutover?

Answer: No new data changes are allowed in the legacy system to ensure a clean final data extract

A data freeze stops changes in the legacy system before the final migration extract, ensuring the migrated dataset is complete and consistent.

Which tool category is commonly used to automate and orchestrate ETL workflows during a CIS data migration?

Answer: ETL/ELT tools such as Informatica, Talend, or Azure Data Factory

ETL/ELT tools like Informatica, Talend, and Azure Data Factory provide visual workflow design, scheduling, error handling, and logging for data migration pipelines.