Question #1724
A company runs a three-tier application in a VPC. The database tier uses an Amazon RDS for PostgreSQL DB instance. The company plans to migrate the RDS for PostgreSQL DB instance to an Amazon Aurora MySQL DB cluster. The company needs a solution that replicates the data changes that occur 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 MySQL read replica on the RDS for PostgreSQL DB instance.
Configure an Aurora PostgreSQL read replica for the RDS for PostgreSQL DB instance.
Define an AWS Database Migration Service (AWS DMS) task with change data capture (CDC) to migrate the data.
Promote the Aurora MySQL read replica to a standalone Aurora MySQL DB cluster when the replica lag is zero.
Explanation
The correct answers are A and D. Here's why:
- A: AWS DMS Schema Conversion Tool (SCT) is required to convert PostgreSQL schema objects (tables, views, etc.) to MySQL-compatible formats, as the engines differ.
- D: AWS DMS tasks with Change Data Capture (CDC) ensure ongoing replication of data changes from the source (PostgreSQL) to the target (Aurora MySQL) during migration.
Why other options are incorrect:
- B/C: Aurora MySQL/PostgreSQL read replicas cannot be created directly from an RDS PostgreSQL instance due to engine incompatibility.
- E: Promoting a read replica is irrelevant here, as cross-engine read replicas are not supported.
Key Points:
1. Use AWS DMS Schema Conversion for cross-engine schema migration.
2. Use DMS CDC for continuous data replication during migration.
3. Cross-engine read replicas are not supported in RDS/Aurora.
Answer
The correct answer is: AD