An organization is looking to migrate from a very large on-premises MySQL Database to an Amazon RDS MySQL Database cluster. The organization is particularly concerned about minimizing the impact on application availability. Since the migration data set is very large, the organization would also like to minimize any data transfer costs. 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 a read replica of the source database.After the migration is complete, promote the read replica to a stand-alone database.
D.Use Percona XtraBackup utility to create backup files from the source database to an Amazon S3 bucket. Restore the Aurora MySQL DB cluster from those files.

Answer: B
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.It also does not take advantage of database compatibility between the on-premises MySQL database and the Aurora MySQL cluster.
Option B is CORRECT because mysqldump utility can be used to create a backup of the existing on-premise database. The backup can then be transferred in compressed form to the AWS cloud.Finally, mysqldump utility can be used to restore the data into an RDS instance.
Option C is incorrect because it is possible to create an Aurora Replica of an existing RDS MySQL database. It is not possible to create an Aurora Replica of an on-premise MySQL database.
Option D is incorrect because it is not the optimal solution. Using mysqldump utility is a more optimal solution from data transfer costs and application availability perspective.
Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.NonRDSRepl.html