An organization has a hybrid cloud architecture consisting of its on-premises datacenter and AWS cloud-connected using AWS Direct Connect. The organization is looking to migrate from an on-premises MySQL Database to an Amazon Aurora MySQL Database cluster. What is the optimal solution for performing data migration in this scenario? The organization is particularly concerned about performing the migration as fast as possible.

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.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: D
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 incorrect because it is not the most optimal solution. It is not the fastest approach to performing the database migration.
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 CORRECT because the Percona XtraBackup utility can be used to create backup files from the source database to an Amazon S3 bucket. XtraBackup utility can copy source database backup files directly to S3.These files can then be directly imported into an Aurora MySQL cluster using the “Restore from S3” option. As mysqldump utility uses DDL and DML statements to recreate the database schemas and load the data, it is a very time consuming process. Therefore, using XtraBackup utility backups is a preferred method when time is a high priority consideration.
Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Migrating.ExtMySQL.html