Migration & Transfer

An organization needs to migrate an on-premises PostgreSQL database to Amazon Aurora PostgreSQL. The organization requires the source database to remain operational and available to applications throughout the migration. Which AWS service is most appropriate?

AWS Database Migration Service

A company is migrating an Oracle database to Amazon Aurora PostgreSQL. The company needs to continuously replicate changes made to the source database while the migration is occurring. Which DMS capability should be used?

Change Data Capture (CDC)

A company is migrating a database from Oracle to Aurora PostgreSQL. The source contains thousands of stored procedures and functions written specifically for Oracle. Which AWS service should be used to assist with converting the database schema and code?

AWS Schema Conversion Tool (SCT)

Which scenario would NOT generally require AWS Schema Conversion Tool?

On-premises PostgreSQL to Amazon RDS for PostgreSQL

A company wants to migrate an on-premises MySQL database to Amazon Aurora MySQL. The source database must remain available during the migration. Which combination is most appropriate?

DMS only

A data engineer is configuring AWS DMS. Which component performs the replication tasks?

DMS replication instance

A company needs to migrate data from an on-premises database to AWS while minimizing downtime. Which DMS strategy is most appropriate?

Perform a full load followed by CDC

A company enables Multi-AZ for its DMS replication instance. What is the primary benefit?

It provides a synchronous standby replication instance in another AZ

A company needs to transfer large amounts of files from an on-premises NFS file system to Amazon S3 every night. Which service is most appropriate?

AWS DataSync

A company needs to synchronize files from an on-premises SMB file server to Amazon EFS. Which service should be used?

AWS DataSync

Which statement about AWS DataSync is correct?

It can transfer data between on-premises storage and AWS storage services

A company transfers data from an on-premises NFS server to Amazon S3 using DataSync. What component is generally required at the on-premises location?

DataSync Agent

A company wants to perform recurring transfers from on-premises storage to AWS on a daily schedule while preserving file permissions and metadata. Which service is most appropriate?

AWS DataSync

A data engineer needs to transfer data between Amazon S3, Amazon EFS, and Amazon FSx. No on-premises systems are involved. Which service can perform this transfer?

AWS DataSync

A media company needs to migrate 5 PB of video data from an on-premises data center to Amazon S3. Its network connection is slow and transferring the data over the network would take several months. Which solution is most appropriate?

AWS Snow Family

A company has a 1 PB dataset and determines that transferring it over the network would take more than a week. Which approach should the company consider?

AWS Snow devices

Which situation most strongly favors AWS Snow Family over AWS DataSync?

Migrating petabytes of data over a severely bandwidth-constrained connection

A financial institution currently uses SFTP to exchange files with external partners. The company wants to move the file-transfer infrastructure to AWS without requiring partners to change their SFTP integrations. Which service should be used?

AWS Transfer Family

A company wants to provide external partners with an AWS-hosted SFTP endpoint while storing uploaded files in Amazon S3. Which service is most appropriate?

AWS Transfer Family

Before migrating a large on-premises environment, a company needs to discover server configurations, utilization information, running processes, and dependencies between systems. Which service should be used?

AWS Application Discovery Service

A company wants to lift and shift physical and virtual servers to AWS with minimal changes to the applications. Which service should be used?

AWS Application Migration Service

A company needs to identify dependencies between applications before deciding which servers should be migrated together. Which service is most appropriate?

AWS Application Discovery Service

Which of the following can be a source for AWS DMS?

Amazon S3

Which database engines are listed as possible DMS sources from on-premises or EC2 instances?

Oracle, SQL Server, MySQL, MariaDB, PostgreSQL

Which Azure database is listed as a DMS source?

Azure SQL Database

Can Amazon RDS be a source of AWS DMS?

Yes

Which statement about Amazon RDS as a DMS source is correct?

All RDS databases, including Aurora

Which of the following is NOT listed as a DMS source on the slide?

Amazon Redshift

A company has a MySQL database running in its on-premises data center. It wants to migrate the database using AWS DMS. In this scenario, what is the DMS source?

On-premises MySQL

A company has an Oracle database running on an EC2 instance. It wants to migrate the database using AWS DMS. What is the source?

Oracle database running on EC2

A company wants to migrate data from an Amazon RDS database to another supported database using AWS DMS. Can the RDS database serve as the source?

Yes

A company stores data in Amazon S3 and wants AWS DMS to read that data as part of a migration. Based on the course slide, can S3 be a DMS source?

Yes

A company uses Amazon DocumentDB and wants to migrate its data using AWS DMS. According to the slide, can DocumentDB be a source?

Yes

Which of the following is a valid AWS DMS source?

Amazon S3

Which of the following is a valid DMS source?

Amazon DocumentDB

A database is running on EC2 using PostgreSQL. The company wants to use AWS DMS to migrate it. Is this supported as a source according to the course?

Yes

A company has an Azure SQL Database and wants to use AWS DMS. Which role does Azure SQL Database play?

DMS Source

Which pairing is CORRECT?

S3 → DMS source

Which of the following groups contains ONLY DMS sources from the slide?

S3, DocumentDB, RDS, Azure SQL Database

On-Premises and EC2 instances databases SOURCES

Oracle

MS SQL Server

MySQL

MariaDB

PostgreSQL

MongoDB

SAP

DB2

Azure SQL Database is a source or target?

source

Amazon RDS (including Aurora) is a source or target?

source

Amazon S3 is a source or target?

source

DocumentDB is a source or target

source

Amazon RDS is a source or target

Target

Redshift, DynamoDB, and S3 are sources or targets?

targets

OpenSearch Service is a source or target?

target

Kinesis Data Streams is a source or target?

target

Apache Kafka is a source or target?

target

DocumentDB & Amazon Neptune is a source or target?

Target

Redis & Babelfish is a target or source?

target

On-Premises and EC2 instances databases

Oracle

MS SQL Server

MySQL

MariaDB

PostgreSQL

SAP