Migration Flashcards

1
Q

Regarding database migration, what is SCT and what does it do?

A

Schema Conversion Tool

Allows you to convert database schemas from one engine to another.

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

What is DMS on a high level?

A

A server running replication software

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

What are the database migration steps when using DMS? (5)

A
  1. Create Source and Target connections
  2. Migrate the database Schema
  3. Set up the data replication process
  4. Initiate the full load (and a subsequent CDC) and apply
  5. Switch your production environment to the new database

Step 5 doesn’t apply to CDC only migrations.

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

TRUE or FALSE?
DMS cannot migrate between source and target endpoints that have different engines.

A

FALSE

It can, using the Schema Conversion Tool

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

TRUE or FALSE?
You can use AWS Schema Conversion Tool to convert databases running on EC2 or data stored in S3

A

TRUE

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

What are the 3 different database migration types to know for the exam?

A
  • Full Load
  • Full Load and Change Data Capture (CDC)
  • CDC only
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is Full Load migration?

A

All existing data from the source is moved to the target.

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

What is Full Load and CDC migration?

A

All existing data from the source is moved to the target.

CDC captures changes to the source tables during migration.

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

Which AWS services would you use to migrate large data stores?

A

AWS Snowball with DMS

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

What problem can occur when migrating large data stores?

A

Network throttling

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

What is a CDC only migration?

A

It does not move any pre-existing data.
Only the changes that occur on the source database after the migration starts are moved.

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

What are some use cases for a CDC only migration? (3)

A
  • Logging what data has changed
  • Replicating data between different environments (e.g. development and testing)
  • Real time data integration (i.e. to feed data into other systems in real time, e.g. for analytics)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

TRUE or FALSE?
When using DMS, one of the endpoints must be within AWS.

A

TRUE

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

What does SMS stand for?

A

Server Migration Service

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

Migration Hub is a place to… (3)

A
  • Discover existing servers
  • Plan migrations
  • Track migration status

It works with other services to actually do the migrations.

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

What are the migration phases?

A
  1. Discover (find servers and dbs to plan your migration)
  2. Migrate (connect tools to migration hub and begin migrating)
  3. Track
17
Q

What does SMS do?

A

Automates migrating on-prem servers to AWS

18
Q

How does SMS work?

A

It replicates server VMs to AWS AMIs. These can then be deployed on EC2 instances.

19
Q

TRUE or FALSE?
Migration Hub carries out your migration

A

FALSE

It just plans it, it doesn’t do it for you.

20
Q

Exam tip: For questions involving tracking and planning migrations, think of…

A

Migration Hub

21
Q

What are 3 benefits that SMS provides?

A

Server Migration Service

  • Simplifies migrations
  • Migrates different types of VMs, incl. from other cloud providers
  • Minimizes downtime
22
Q

What is the pricing model for DMS?

A

You only pay for the replication instances and any additional log storage.

Data transfer is free.

23
Q

When would you NOT use Direct Connect for migration?

A
  • Too much data
  • You don’t need the connection to the DC after the migration is done
24
Q

What are the devices in the Snow Family in order of size?

A

Snowcone
Snowball Edge
Snow Mobile

25
Q

How much storage do you get with Snowcone?

A

8 TB

26
Q

What are two use cases for Snowcone?

A
  • IoT stuff
  • data that’s already been processed
27
Q

How much storage do you get with Snowball Edge?

A

approx 50 to 80 TB

28
Q

What are two use cases for Snowball Edge?

A
  • off-grid computing
  • migration
29
Q

How much storage do you get with Snow Mobile?

A

100 PB