A database migration requires moving a 5 TB MySQL database from on-premises to Amazon Aurora MySQL. The migration must have less than 10 minutes of downtime. Which TWO tools should be used together? (Select TWO)

Answer options:

AWS Database Migration Service (DMS) for ongoing replication.

AWS Snowball Edge for the ongoing replication.

Percona XtraBackup or mysqldump for the initial data load.

AWS Schema Conversion Tool (SCT).

AWS DataSync.

AWS Application Migration Service (MGN).

How to approach this question

Combine native bulk load tools with AWS replication tools.

Full Answer

For large homogeneous migrations, best practice is to use native tools (mysqldump/Percona) for the fast initial load, and AWS DMS for the ongoing Change Data Capture (CDC) to achieve near-zero downtime.

Common mistakes

Using DMS for the initial load of a massive database, which is very slow.

Question 58 All questions Question 60

Practice the full AWS Solutions Architect Professional SAP-C02 Practice Exam 3

75 questions · hints · full answers · grading

More questions from this exam

Q01An enterprise has 100 VPCs across 5 AWS Regions. They need to establish a highly available, trans...Hard Q02A company uses AWS Organizations. The CISO requires that no EC2 instances can be launched outside...Medium Q03An application uses Amazon Aurora PostgreSQL. To meet disaster recovery requirements, the databas...Hard Q04A company is setting up a new multi-account AWS environment. They want to automate the creation o...Medium Q05An organization wants to allocate AWS costs to specific departments. They use multiple AWS accoun...Medium

View all 75 questions →