A company runs a critical database on Amazon RDS for PostgreSQL and wants to migrate to Amazon Aurora PostgreSQL with minimal downtime and data loss, and with the least operational overhead. Which solution meets these requirements?
Choose an answer
Tap an option to check your answer.
Correct answer: Create an Aurora read replica of the RDS for PostgreSQL DB instance. Promote the Aurora read replicate to a new Aurora PostgreSQL DB cluster..
Why this is the answer
Creating an Aurora read replica of the RDS for PostgreSQL instance allows for continuous data synchronization with minimal downtime. Once the replica is fully caught up, promoting it to a standalone Aurora PostgreSQL DB cluster completes the migration with very little data loss, as the promotion process is quick. This method also has low operational overhead because AWS manages the replication and promotion. Creating a DB snapshot involves downtime during the snapshot creation and restoration, and the data will be as old as the snapshot. Using data import from Amazon S3 or pgdump requires significant downtime for exporting and importing data, and these methods are more complex to manage and prone to data inconsistencies during the migration window.
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