CISA · Question #270
Which of the following should be the FIRST step in a data migration project?
The correct answer is C. Understanding the new system's data structure. The first step in any data migration project is to thoroughly understand the new system's data structure, as this defines the target for all migrated data.
Question
Which of the following should be the FIRST step in a data migration project?
Options
- ACreating data conversion scripts
- BCompleting data cleanup in the current database to eliminate inconsistencies
- CUnderstanding the new system's data structure
- DReviewing decisions on how business processes should be conducted in the new system
How the community answered
(23 responses)- B4% (1)
- C87% (20)
- D9% (2)
Why each option
The first step in any data migration project is to thoroughly understand the new system's data structure, as this defines the target for all migrated data.
Creating data conversion scripts is a step that comes after understanding both the source and target data structures, as the scripts depend on this understanding.
Completing data cleanup in the current database is a crucial preparation step, but it typically happens after the target structure is understood and mapping requirements are clear, as the cleanup often aligns with the needs of the new system.
Before any data can be moved or transformed, it is fundamental to understand the target environment. Understanding the new system's data structure, including its schema, data types, relationships, and constraints, is the absolute first step, as this knowledge dictates how existing data needs to be mapped, transformed, and loaded.
Reviewing decisions on how business processes should be conducted in the new system is important for overall system design and functionality, but it's a higher-level activity; the technical data migration specifics must start with understanding the data structures.
Concept tested: Data migration project initiation
Topics
Community Discussion
No community discussion yet for this question.