Data Migration Flashcards

1
Q

__________ is the process of transferring data from one location, format, or application to
another.
● It requires careful planning and execution to _______ and ensure a _________
● The primary goal is to ensure that data remains accessible, accurate, and secure throughout the
process.
● The process begins with _________, where the data to be migrated is identified and
analyzed.
● Data extraction from source systems is done using___________.
● ____________occurs if there are disparities in data format or structure between source and
target systems. The transformed data is loaded into the target system.
● _________is crucial to avoid disruptions, often involving planned downtime or reduced
system activity.
● After confirming a successful migration, the old source system is __________ safely

A

Data migration
minimize risks
smooth transition
assessment and planning
tools, scripts, or APIs.
Data transformation
Migration scheduling
decommissioned

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

The following are some common scenarios that require ________:
● Replacement, upgrade, and expansion of storage systems and equipment
● Legacy software upgrade and replacement
● Firms moving from local storage system to a cloud-based system to optimize operations
● Website consolidation
● Installation of new systems to coexist and augment existing applications sharing the same dataset
● Infrastructure maintenance
● Switching to centralized databases to attain interoperability
● Consolidation of information systems
● Data center relocation

A

data migration

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Businesses usually take up data migration when they have to move data between storage systems, upgrade to a
new software platform, or transition to a cloud-based infrastructure.

Here are some more reasons why businesses migrate data:

____________: As technology evolves, enterprises often need to update their software,
hardware, or infrastructure. Data migration allows them to seamlessly transition to newer systems while
preserving critical data and minimizing disruption.

_____________: Over time, data can become scattered across various systems and locations. Data
migration enables businesses to
consolidate data, making it easier to manage, access, and analyze.

______________: Organizations must comply with data protection regulations and ensure data
security. Data migration allows them to meet compliance requirements and safeguard sensitive information
during transfer.

_______________: When businesses expand or merge with others, they must integrate
data from multiple sources or locations. Data migration facilitates this process, enabling a smooth transition
of data and systems.

A

Upgrading Technology
Data Consolidation
Compliance and Security
Business Expansion and Mergers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Types of Data Migration
There are six types of data migration. A single data migration process can involve different types,
including:

A
  1. Storage Migration
  2. Database Migration
  3. Application Migration
  4. Cloud Migration
  5. Business Process Migration
  6. Data Center Migration
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

______________ is where a business migrates data from one storage location to another. It means moving data from one
physical medium to another. A common reason for storage migration is the ______ of storage equipment to more
sophisticated modern storage equipment. Hence, it encompasses movement from paper to digital, tapes to hard disk drives
(HDD), HDD to solid-state drives, and hardware-based storage to virtual (cloud) based storage.

The movement is not driven by a lack of space but rather a desire to upgrade storage technology. It normally ________ alter
the content or format of data. During storage migration, certain steps such as data validation, cloning, and data cleaning
and redundancy can be carried out

A

Storage migration
upgrading
does not

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

________ are data storage media where data is structured in an organized way. Databases are managed through___________.
Hence, _____________ involves moving from one DBMS to another or upgrading from the current version of a DBMS to
the latest version of the same DBMS.

The former is more __________ especially if the source system and the target system
use different data structures

A

Databases
database
management systems (DBMS).
database migration
database migration

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

____________ occurs when an organization goes through a change in application software or changes an
application vendor. This migration requires moving data from one computing environment to another. A new __________ may require radical transformation due to new application interactions after the migration.

The major challenge comes from the old and target infrastructures having distinctive data models and using_________ . ____________ can be provided by vendors to protect data integrity. Vendor web
interfaces may be scripted to facilitate data migratio

A

Application migration
application
platform
different data
formats
Application programming interfaces (APIs)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

______________ requires the movement of business applications and data on business processes and metrics
to a new environment. The metrics can include customer, product, and operational information.

The migration is commonly instigated by business optimization and reorganization and mergers and acquisitions (M&A).
Such business combinations are necessitated by the need to enter new markets and remain competitive.

A

Business process migration

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

____________ relates to the migration of data center infrastructure to a new physical location or the movement of
data from the old data center infrastructure to new infrastructure equipment at the same physical location.
A ___________ houses the data storage infrastructure, which maintains the organization’s critical applications. It consists of
servers, network routers, switches, computers, storage devices, and related data equipment

A

Data center migration
data center

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Extent of Data Migration
________ can also be classified by the extent to which the data is migrated. A few classifications include:
1. Full Migration
2. Partial Migration
3. Incremental Migration
4. Pilot Migration

A

Migration

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

_____________ involves transferring all of the data from one system to another. This form of migration often requires
significant time and resources, as it includes replicating existing live systems.

This type of migration is often used when
moving from legacy systems to modern platforms or for large-scale projects that involve migrating a full set of records.

Nuances: Requires a ___________ approach. There might be__________, especially when dealing with legacy systems.

Key considerations: Ensuring________ , mitigating downtime, integration and testing, planning for unforeseen
challenges, and ensuring stakeholder communication

A

Full migration

comprehensive and often resource-intensive

compatibility and integration
challenges

data consistency

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

_____________
Migrating select portions of the data, often just critical data. Useful when full migration is unnecessary or risks are too high.

Nuances: _________ which data sets to move can be challenging. Data dependencies might make this migration more
complicated than initially perceived, as interconnected data may require movement to maintain operational functionality.

Key considerations: Clearly _________ the data subset, understanding interdependencies, ensuring data integrity for the
migrated subset, and managing potential post-migration integration issues

A

Partial Migration
Prioritizing
defining

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

____________
Migrating a subset of data for testing the process before a full-scale migration. Helps in avoiding major disruptions or issues
in production systems.

Nuances: The subset chosen for pilot migration needs to be __________ of the broader dataset to provide valuable
insights. There’s a balance to be struck between having a dataset substantial enough for meaningful testing, but small
enough to mitigate risks.

Key considerations: _______ of a representative data subset, setting clear evaluation criteria for the pilot’s success, having
a rollback plan in place, and ensuring effective communication with stakeholders about the pilot’s purpose and expected
outcomes

A

Pilot Migration

representative

Selection

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

____________ occurs when data migrates from one system to another that is similar in architecture, operating system, or design.
Data can be easily transferred between systems and preserved in an identical format.

Nuances: Homogeneous migrations tend to be more __________, as there is little to no conversion required between the systems.

Key considerations: Ensuring data _________________, validating post-migration performance, addressing compatibility issues if present, and
planning for any significant downtime during the process.

A

Homogeneous migration
straightforward
accuracy and consistency

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

_______________ is the process of migrating data from one type of system to another that are dissimilar in architecture, operating system, or
design. This type of migration requires extensive planning, as data needs to be converted into a compatible format for the target system.

Nuances: Data may need to be ___________ in order to be compatible with the target system, which can introduce complex
challenges.

Key considerations: Data format _______, compatibility issues that might arise from disparate systems, ensuring data accuracy post-migration,
mitigating downtime

A

Heterogeneous migration

transformed and converted

conversions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Data Migration Process

___________ Evaluating sets of existing data for stability complications.

____________ Inspecting the scope of the data that is to be migrated in terms of quality, conflicts, or any possible anomalies.

__________ Backing up all data that is to be migrated to guard against any migration failure that can lead to data loss.

____________ Stipulating procedures, responsibilities, and other personnel criteria for the migration.

___________ Ensuring the migration process has been executed as per set guidelines and validating the data for business use.

____________ Post-migration step in which the old system is shut down and decommissioned.

A

Pre-migration Planning:
Data Inspection:
Data Backup:
Migration Design:
Execute & Validate:
Decommission & Monitor:

17
Q

The data migration process can also follow _______

__________ can manage the complexities of the data migration process from processing huge datasets, profiling, and
integration of multiple application platforms

A

● Extraction of data
● Transformation of data
● Loading data

ETL process

18
Q

The data migration process remains the same whether a
big bang approach
or a
trickle approach
overview of the two approaches is given as follows:

  1. _________________
    ● Moves all data in a single operation from the current to the target environment.
    ● Fast, less complex, and lower cost.
    is adopted. A brief
    ● Requires complete system downtime during migration, so it’s done during off-hours or public holidays.
    ● Suitable for small companies or projects with smaller amounts of data.
    ● Risk of failure due to overwhelming network transmission with large data sets.
    ● Not suitable for systems that cannot tolerate any downtime.

2.______________
● Phased approach to migration, breaking down the process into sub-processes where data is transferred in small increments.
● The old system remains operational and runs parallel to the migration.
● No downtime for the live system, making it less prone to errors and failures.
● More complex and takes longer to complete due to its iterative nature.
● Requires data synchronization between the old system and the new environment.
● Ideal for big data organizations that cannot afford any system downtime.

A

Big Bang Data Migration Approach
Trickle Data Migration Approach

19
Q

Data Migration Best Practices
There are some best practices that should be observed when conducting a data migration exercise to ensure the process is
seamless with a high degree of success whilst avoiding costly delays.
● A dedicated migration team should be set up with the right specialists in place to manage and steer the project.
● Data migration should be a chance to __________ its quality standard before it is transmitted so as not to
inherit inferior quality data with old problems.
● The amount of data to be migrated should be ________ as much as possible. Data cleaning can assist in ensuring
that only quality and useful data is migrated.
● All data should be _______ before writing mapping scripts.
● Backup data before the migration begins to guard against data loss.
● Keep testing the migration from planning and design stages to execution and maintenance to guarantee the success
of the migration project.
● The old system should only be switched off after confirmation of the success of the migration process. If it fails, a
roll-back will be necessary with no downtime as the old system will still be running

A

clean data and raise
right-sized
profiled

20
Q

Data Migration Risks

Data migration risks include the following:
_______ Data can be lost during migration; hence, it is crucial to back up and plan the migration diligently with
help from professionals.

_________ Data migration can take a long time, from a few months to several years, and can be
prolonged if the process encounters network blockages that can affect transmission times. Connection speeds and
infrastructure limitations can also affect the progress of the migration.

_____________ – Data should be encrypted before migration to ensure security.

______________ – Prolonged migration can lead to breaking the budget. Personnel and vendor software costs
may outstrip budgeted amounts leading to financial challenges that can threaten the success of the migration
process.

A

● Losing data
● Prolonged migration time
● Data security
● Breaking the budget

21
Q

Introduction to Database Migration Tool

To achieve greater efficiency and agility and reduce IT expenditures, more firms are now relocating their
workloads and data to new types of data storage and processing systems as well as cloud-based services. As
businesses adopt new technologies and transition to the public cloud or hybrid infrastructures, they need tools
that allow them to move large data sets to new platforms on-premises and in the cloud easily, quickly, and
without ________________

A

disrupting user access

22
Q

The Advantages of a Database Migration Tool
● A ___________ allows firms to transfer data between databases or to other data
repositories (e.g., data warehouse, data lake) without manual coding or complex ETL tools.
● It uses ____________ to ensure smooth transitions with minimal or no downtime.
● ______________ maintains both database and operating system integrity, avoiding
data consistency issues.
● ____________ tools enable users to configure and execute migrations via a graphical designer
or mapping tool, eliminating the need for hand-coding.
● If equipped with ______________, the tool supports low-impact,
low-latency continuous data replication.
● ______________ and pre-switchover testing, with fallback options post-switchover, are
possible with these tools.
● The tool helps mitigate risk, accelerates the migration process, and reduces the cost of migration
projects by offering various built-in features

A

database migration tool
database replication software
Replication-based migration
Modern migration

log-based change data capture (CDC) technology

Zero-downtime migrations

23
Q

Examples of data migration tools include the following among others:

A

● IBM InfoSphere
● CloverDX
● Microsoft SQL
● Oracle Data Service Integrator
● Informatica PowerCenter
● IRI NextForm
● Xplenty
● AWS Data Migration
● Azure DocumentDB
● Talent Open Studio

24
Q

How the Right Data Migration Tool Benefits Enterprises

____________ A suitable data migration tool automates and streamlines the migration process and reduces
the time and effort required to move data.

__________: Data migration tools include
data validation and transformation features, ensuring that data is
migrated accurately. Robust data quality features reduce the risk of errors, data corruption, or data loss during the
migration process.

_________________ Leveraging an efficient data migration tool allows enterprises to quickly adapt to changing
market needs. These tools enable seamless transition to new systems, platforms, or cloud environments and allow
businesses to outpace competitors, respond swiftly to market shifts, and enhance customer offerings.

A

● Efficiency and Speed:
● Data Accuracy
● Competitive Advantage:

25
Q

How To Select the Right Data Migration Tool for Your Organization?

____________
Make sure that the tool chosen can scale to handle large data volumes effectively. It should be able to grow alongside your organization’s needs.

_________
Consider the reliability of the data migration tool to maintain
data integrity and minimize downtime during migration projects. It should offer robust error handling
and recovery features to ensure a smooth migration process.

_____________
Opt for a tool that seamlessly integrates with your existing systems and adapts to different data formats and sources. This flexibility is crucial when dealing with
diverse data sources and technology stacks.

______________
Look for a tool with an intuitive design and clear usability that can significantly enhance the efficiency of your migration process, reduce the risk of errors, and
ensure smoother data transfers. Prioritize tools that are easy to navigate and require minimal training for your team.

__________
Confirm that the chosen tool adheres to relevant industry standards and data protection regulations such as GDPR, HIPAA, etc.

_______________
Ensure that the tool empowers customization and extensibility to accommodate unique data migration scenarios.

A

Scalability
Reliability
Compatibility and Adaptability
User-friendly Interface

Regulatory Compliance
Customization and Extensibility