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.)
To migrate a MySQL database to an Aurora PostgreSQL cluster, there are key steps required. First, AWS Database Migration Service (AWS DMS) Schema Conversion can be used to transform database objects, which is essential when converting between different database engines like MySQL to PostgreSQL. Second, defining an AWS DMS task with change data capture (CDC) is necessary to ensure that ongoing data changes are captured and migrated to the new database, maintaining data consistency during the migration process.
AD makes sense to me, but I am not sure if that's the best answer.
Agreed. AD makes more sense !!
Correct answer BE
It's quite similar with Q.235, based on that discussion A-D makes more sense.
A: Correct. because need convert from MySQL to PostgreSQL B: Wrong. Schema Conversion does not create an Aurora read replica C: Wrong. Company wants to migrate to Aurora PostgreSQL, not Aurora MySQL D: Correct. CDC task helps to capture ongoing change from source data store E: Wrong. Although using Aurora Read Replica is an option for DB migration within the same Region, this question is asking for "combination of steps", which this option does not have another compatible option to pair with Therefore, answer is "AD"
Lag many never be zero, then it will ne er be promoted to primary
AnswerAD