To increase the performance of its database solution, an organization is looking to migrate from its RDS MySQL database instance to an Aurora MySQL Database cluster. What is the optimal solution for performing data migration in this scenario?

Answer options:

A.Use the AWS Database Migration Service (DMS) to migrate the data.
B.Use the MySQL mysqldump utility to copy the data.
C.Create an Aurora Read Replica of the source database. After the migration is complete, promote the Aurora Read Replica to a stand-alone DB cluster.
D.Copy the backup files from the source database to an Amazon S3 bucket. Restore the Aurora MySQL DB cluster from those files.

Answer: C
Option A is incorrect because using DMS in this scenario is not the most optimal solution from an operational and cost-effective point of view.It requires manual planning and execution of migration steps and additional infrastructure to support DMS.
Option B is incorrect because it is not the most optimal solution. It requires manual steps to perform the data migration, and it does not take advantage of native capabilities offered by AWS.
Option C is CORRECT because it is possible to create an Aurora Replica of an existing RDS MySQL database.This automatically migrates the data from source to target.Once data migration is complete, it is possible to promote the read replica to a stand-alone cluster.This is the recommended approach to migrate data from the RDS MySQL database to an Aurora MySQL Cluster.
Option D is incorrect because it is not the most optimal solution.It requires manual steps to perform data export and import. Additionally, it incurs costs associated with S3 storage.
Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Migrating.RDSMySQL.Replica.html