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.)
Choose an answer
Tap an option to check your answer.
Correct answer: Use AWS Database Migration Service (AWS DMS) Schema Conversion to transform the database objects., Define an AWS Database Migration Service (AWS DMS) task with change data capture (CDC) to migrate the data..
Why this is the answer
Migrating from MySQL to PostgreSQL involves a schema conversion because the database engines are different. AWS DMS Schema Conversion (formerly AWS SCT) is designed for this purpose, transforming database objects like tables, stored procedures, and functions from one engine to another. After schema conversion, AWS DMS with change data capture (CDC) is essential for migrating the actual data. CDC ensures that any changes happening in the source MySQL database during the migration process are continuously replicated to the target Aurora PostgreSQL database, minimizing downtime. Creating an Aurora PostgreSQL read replica for an RDS for MySQL instance is not possible as they are different database engines. Configuring an Aurora MySQL read replica is not relevant for a migration to Aurora PostgreSQL. Promoting a read replica is a step taken after a successful replication, not a core migration step for cross-engine migration.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed