AWS Database Migration Service Flashcards

1
Q

What is AWS Database Migration Service?

A

The DMS will help you migrate a database from DB-A to DB-B. This includes schema changes.

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

What are the ways to migrate SQL databases to AWS, this includes using DMS?

A
  • Using SQL servers native backup and restore
  • SQL server replication
  • Using DMS to bulk load the data and replicate on-going changes
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Is DMS a fully managed service?

A

It is a managed service but a VM is deployed into a VPC, this is the VM that is used to perform the database migration?

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

What sources are supported?

A
  • Mongo DB
  • DB load and capture form S3
  • Oracle
  • MS SQL Server
  • MySQL
  • MariaDB
  • Postgres
  • Db2 LUW
  • Azure SQL
  • RDS database instances
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What are the target database types?

A

-Mongo DB
- DynamoDB
- Elastic search
Kinesis data streams
- DB load and capture form S3
- Oracle
- MS SQL Server
- MySQL
- MariaDB
- Postgres
- Db2 LUW
- Azure SQL
- RDS database instances

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

What is a replication instance used for in DMS?

A

It is an instance or instance + standby in Multi-AZ that is used to replicate the data from DB-A to DB-B.

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

What must you consider when selecting the replication instance?

A

The size, you need to select a size that will be large enough to give you the performance you need.

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

How will the replication instance connect to the databases from its VPC?

A

There are two different situations, the replication instance gets a private IP and also can have a public IP. The public IP can be used what your database can be accessed over the public internet. The private IP can be used when VPN, directconnect or database is in the vPC. You can also connect using VPC peering.

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

How is security handled for the DMS service?

A

Data at rest is encrypted, this is the replication instance data, using the KMS. SSL is used for connections

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

Where does cloud migration service send its logs?

A

To the CloudWatch logs service.

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

What is a DMS task?

A

You specify what tables and schemas to use for your migration and any special processing, such as logging requirements, control table data, and error handling.

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

How does the DS perform the migration?

A

DMS performs the following functions,

  • Copy or convert scheme to destination
  • Copy data to the destination
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is AWS SCT?

A

AWS SCT is the AWS schema conversion tool

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

What are the source and target endpoints?

A

These are the source and target endpoints for each of the databases DMS will connect to for migration.

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

What type of tasks can you have in DMS?

A
  • Full load, this is where the entire database is copied in one shot.
  • Full load and replication, this is where the database is copied and then ongoing replication happens.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is CDC

A

Change data capture, it is when a SQL database changes data in the tables, this data is captured so it can be replicated.

17
Q

What is full load?

A

This is when we are first performing database replication, we have to prefrom an initial load of all the data and after the load, CDC is performed and the changes replicated.