AWS Certified Solutions Architect – Associate (SAA-C03) — Question 666

A company runs a three-tier application in a VPC. The database tier uses an Amazon RDS for MySQL DB instance.

The company plans to migrate the RDS for MySQL DB instance to an Amazon Aurora PostgreSQL DB cluster. The company needs a solution that replicates the data changes that happen during the migration to the new database.

Which combination of steps will meet these requirements? (Choose two.)

Answer options

• A. Use AWS Database Migration Service (AWS DMS) Schema Conversion to transform the database objects.
• B. Use AWS Database Migration Service (AWS DMS) Schema Conversion to create an Aurora PostgreSQL read replica on the RDS for MySQL DB instance.
• C. Configure an Aurora MySQL read replica for the RDS for MySQL DB instance.
• D. Define an AWS Database Migration Service (AWS DMS) task with change data capture (CDC) to migrate the data.
• E. Promote the Aurora PostgreSQL read replica to a standalone Aurora PostgreSQL DB cluster when the replica lag is zero.

Correct answer: A, D

Explanation

Migrating from MySQL to PostgreSQL is a heterogeneous migration, which requires using AWS DMS Schema Conversion to convert the database schema and objects between the different database engines. To replicate ongoing data modifications during the migration, an AWS DMS replication task configured with Change Data Capture (CDC) must be used. Other options are incorrect because native read replicas cannot be directly created or promoted between different database engines like MySQL and PostgreSQL.