Data Migration

What is data migration?

• movement from one region to another and often back again

• to move something from one place to another

• 
  Transferring data between different formats, storage types, and computer systems

• 
  the activity of collecting information, especially using computers

Choose all data migration risks

• Data loss / corruption

• Takes lots of time

• Incompatibility of type and format

• Types of access

Choose True or False

When moving data from 1 storage device to another data could be corrupted/lost due to incomplete data transfer

• True

• False

Read the examples and choose which data migration risk can be prevented

--> Students may have read-only access, whereas teachers may have the ability to read sensitive data and write files.

• Incompatibility of type and format

• Sold/stolen information

• Frequency of access

• Data loss and corruption

ETL Stands for

• Explain, Transform, Load

• Extract, Transition, Load

• 
  Explain, Transform, Locate

• Extract, Transform, Load

Extract is the process

• of adding new data to a database

• of analyzing collected information

• 
  of reading and collecting data from a database, the data is often collected from multiple sources.

• none of the above

Transform is the process of

• 
  Converting the extracted data from its previous form into the form it needs to be in so that it can be placed into another database

• Having Bill's Mom review it and give it a makeover

• Scrubbing the data to remove unnecessary items

• All of the above

Load is the process of

• 
  of publishing the data to decision makers

• of writing data into a RPA tool

• 
  of reviewing data in the database

• of writing the data into the target database.

ETL is used to migrate data from one database to another

• True

• False

ETL is also used to convert (transform) large databases from one format or type to another.

• True

• False