Which combination of steps will meet these requirements?

By:
In: SAA-C03
Tagged:
With: 1 Comment
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.)

Use AWS Database Migration Service (AWS DMS) Schema Conversion to transform the database objects.

Use AWS Database Migration Service (AWS DMS) Schema Conversion to create an Aurora PostgreSQL read replica on the RDS for MySQL DB instance.

Configure an Aurora MySQL read replica for the RDS for MySQL DB instance.

Define an AWS Database Migration Service (AWS DMS) task with change data capture (CDC) to migrate the data.

Promote the Aurora PostgreSQL read replica to a standalone Aurora PostgreSQL DB cluster when the replica lag is zero.

Explanations:

AWS DMS Schema Conversion is necessary to transform MySQL schema objects to Aurora PostgreSQL format.

AWS DMS does not create Aurora PostgreSQL read replicas for RDS MySQL; this option is incorrect.

Aurora MySQL read replicas can only replicate MySQL, not PostgreSQL; thus, it does not meet the need.

AWS DMS with CDC allows continuous replication of data changes during migration to Aurora PostgreSQL.

Promoting a read replica applies to homogeneous replication; Aurora PostgreSQL needs different steps.

2025-10-24

1 Comment

  1. Ryan
    Author

    Based on what I know, the answer is:
    Use AWS Database Migration Service (AWS DMS) Schema Conversion to transform the database objects.

Leave a Reply to Ryan Cancel reply

Your email address will not be published. Required fields are marked *

five × 3 =