AWS Certified Solutions Architect – Associate (SAA-C02) — Question 794

A company is migrating its on-premises PostgreSQL database to Amazon Aurora PostgreSQL. The on-premises database must remain online and accessible during the migration. The Aurora database must remain synchronized with the on-premises database.
Which combination of actions must a solutions architect take to meet these requirements? (Choose two.)

Answer options

• A. Create an ongoing replication task.
• B. Create a database backup of the on-premises database.
• C. Create an AWS Database Migration Service (AWS DMS) replication server.
• D. Convert the database schema by using the AWS Schema Conversion Tool (AWS SCT).
• E. Create an Amazon EventBridge (Amazon CloudWatch Events) rule to monitor the database synchronization.

Correct answer: A, C

Explanation

To perform a live database migration with minimal downtime, AWS Database Migration Service (AWS DMS) is used. This requires provisioning an AWS DMS replication server to host and run the migration processes, alongside creating an ongoing replication task (Change Data Capture) to continuously synchronize changes from the source PostgreSQL database to the target Aurora PostgreSQL database. Other options like AWS SCT are not required because migrating from PostgreSQL to PostgreSQL is a homogenous migration, meaning the schema does not need conversion.