AWS Certified Database – Specialty — Question 22

A company is running its line of business application on AWS, which uses Amazon RDS for MySQL at the persistent data store. The company wants to minimize downtime when it migrates the database to Amazon Aurora.
Which migration method should a Database Specialist use?

Answer options

• A. Take a snapshot of the RDS for MySQL DB instance and create a new Aurora DB cluster with the option to migrate snapshots.
• B. Make a backup of the RDS for MySQL DB instance using the mysqldump utility, create a new Aurora DB cluster, and restore the backup.
• C. Create an Aurora Replica from the RDS for MySQL DB instance and promote the Aurora DB cluster.
• D. Create a clone of the RDS for MySQL DB instance and promote the Aurora DB cluster.

Correct answer: C

Explanation

The correct answer is C because creating an Aurora Replica allows for a seamless transition with minimal downtime, as the data is continuously replicated. The other options involve either creating backups or snapshots, which can result in longer downtime during the migration process.