AWS Certified Solutions Architect – Associate (SAA-C03) — Question 69

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

The correct answer includes creating an ongoing replication task (A) to ensure real-time synchronization between the on-premises and Aurora databases, and setting up an AWS DMS replication server (C) to facilitate this process. The other options, while relevant to database management, do not fulfill the specific requirement of maintaining online access and synchronization during the migration.