Q50 — AWS SAA-C03 Ch.3

Question 50 of 65 | ← Chapter 3

Q180. 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? (Select TWO.)

Correct Answer: A. Create an ongoing replication task., C. Create an AWS Database Migration Service (AWS DMS) replication server.

Explanation

To meet the requirements of migrating an on-premises PostgreSQL database to Amazon Aurora PostgreSQL while keeping both databases online and accessible, a solutions architect should take the following two actions:A. Create an ongoing replication task using AWS Database Migration Service (AWS DMS) to replicate data from the on-premises PostgreSQL database to Aurora PostgreSQL. This allows for real-time synchronization between the two databases.C. Create an AWS Database Migration Service (AWS DMS) replication server to manage the ongoing replication task. The replication server will handle the migration of data from the on-premises PostgreSQL database to Aurora PostgreSQL, ensuring that the two databases remain in sync throughout the migration process.Creating a backup of the on-premises database (option B) and converting the database schema using AWS Schema Conversion Tool (AWS SCT) (option D) are not necessary steps to complete this migration. Lastly, creating an Amazon EventBridge (Amazon CloudWatch Events) rule to monitor the database synchronization (option E) is an optional step to ensure that the synchronization is working as expected, but it is not required to meet the requirements stated in the question.