AWS Certified Data Analytics Specialty 2021 – Hands-On - Database Migration Service (DMS)

The video tutorial explains how to use AWS Database Migration Service (DMS) to migrate databases from on-premise or other cloud environments to AWS. It covers the types of migrations supported, including homogeneous and heterogeneous migrations, and introduces the AWS Schema Conversion Tool (SCT) for schema conversion. The tutorial provides a step-by-step guide on creating a replication instance, configuring endpoints, and setting up migration tasks. It emphasizes the resilience and self-healing capabilities of DMS, ensuring the source database remains available during migration.

What is the primary purpose of the AWS Database Migration Service?

• To provide backup solutions for AWS databases

• To migrate databases to AWS with minimal downtime

• To create new databases on AWS

• To monitor AWS database performance

Which type of migration does AWS DMS support?

• Only homogeneous migrations

• Only heterogeneous migrations

• Neither homogeneous nor heterogeneous migrations

• Both homogeneous and heterogeneous migrations

What is the role of an EC2 instance in AWS DMS?

• To store the migrated data

• To perform the replication task

• To provide security for the database

• To manage user access

Which of the following is NOT a supported source database for AWS DMS?

• Oracle

• MySQL

• MongoDB

• SQLite

What is the AWS Schema Conversion Tool used for?

• To convert database schemas between different engines

• To delete old databases

• To monitor database performance

• To create new databases

When setting up a DMS replication instance, what is the purpose of the allocated storage?

• To store log files during replication tasks

• To store backup copies of the database

• To store user credentials

• To store the actual data being migrated

What is a key consideration when choosing an EC2 instance class for a DMS replication instance?

• The number of users accessing the database

• The location of the database

• The color of the instance

• The size of the database being migrated