A company is migrating its on-premises PostgreSQL database to Amazon Aurora PostgreSQL. The on-premises database must remain online and accessible during migration, and the Aurora database must stay synchronized with the on-premises database. Which combination of actions must a solutions architect take? (Choose two.)
Choose an answer
Tap an option to check your answer.
Correct answer: Create an ongoing replication task., Create an AWS Database Migration Service (AWS DMS) replication server..
Why this is the answer
To migrate an on-premises PostgreSQL database to Amazon Aurora PostgreSQL with minimal downtime and continuous synchronization, AWS Database Migration Service (DMS) is the appropriate tool. AWS DMS requires a replication instance (server) to perform the data migration. This replication instance connects to both the source (on-premises PostgreSQL) and target (Aurora PostgreSQL) databases. An "ongoing replication task" within DMS ensures that after the initial full load of data, any subsequent changes (like inserts, updates, and deletes) on the source database are continuously replicated to the target Aurora database. This maintains synchronization until the cutover to Aurora. "Create a database backup of the on-premises database" is a good practice but doesn't facilitate continuous synchronization. "Convert the database schema by using the AWS Schema Conversion Tool (AWS SCT)" is often used before DMS for heterogeneous migrations, but for PostgreSQL to Aurora PostgreSQL (a homogeneous migration), schema conversion is usually minimal or not strictly required for the core migration process, and it doesn't handle data synchronization. "Create an Amazon EventBridge (Amazon CloudWatch Events) rule" could monitor DMS tasks but is not a core action for setting up the migration and synchronization itself.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed