CIS CIS Data Migration & Integration 1 — Questions and Answers
Question 1: What is the primary goal of an ETL process in a CIS data migration?
- Extract, Test, and Launch data to production
- Extract, Transform, and Load data from source to target systems (Correct answer)
- Evaluate, Transfer, and Log migration errors
- Encrypt, Transmit, and Lock sensitive records
Correct answer: Extract, Transform, and Load data from source to target systems
ETL (Extract, Transform, Load) is the process of pulling data from source systems, converting it to fit the target format, and loading it into the destination system.
Question 2: During CIS data migration planning, a data profiling exercise is conducted to:
- Define user access permissions
- Assess the quality, completeness, and structure of source data (Correct answer)
- Configure API endpoints
- Train end users on the new system
Correct answer: Assess the quality, completeness, and structure of source data
Data profiling analyzes source data to understand its quality, completeness, and structure before mapping it to the target system.
Question 3: Which type of integration connects two systems in real time so that data changes in one system are immediately reflected in the other?
- Batch integration
- Point-to-point integration
- Real-time or event-driven integration (Correct answer)
- File-based integration
Correct answer: Real-time or event-driven integration
Real-time or event-driven integration propagates data changes immediately between systems, often using APIs or message queues.
Question 4: A data mapping document in a CIS migration project defines:
- The network topology between servers
- The correspondence between source fields and target fields (Correct answer)
- The list of users who can access the system
- The project risk register
Correct answer: The correspondence between source fields and target fields
A data mapping document specifies how each field from the source system corresponds to fields in the target system, including any transformation rules.
Question 5: What is a 'cutover plan' in the context of CIS data migration?
- A plan for cutting project costs
- A detailed sequence of steps to switch from the old system to the new system (Correct answer)
- A list of features cut from scope
- A rollback procedure for failed integrations
Correct answer: A detailed sequence of steps to switch from the old system to the new system
A cutover plan documents the precise sequence of activities, responsibilities, and timing required to transition from the legacy system to the new one.
Question 6: Which migration strategy involves running old and new systems simultaneously for a period to validate the new system before fully decommissioning the old one?
- Big Bang migration
- Phased migration
- Parallel run migration (Correct answer)
- Trickle migration
Correct answer: Parallel run migration
A parallel run keeps both systems active simultaneously, allowing comparison of outputs and reducing risk before committing fully to the new system.
CIS CIS Data Migration & Integration 1
What is the primary goal of an ETL process in a CIS data migration?