Q20 — AWS SAA-C03 Ch.11

Question 20 of 100 | ← Chapter 11

Q720. A company runs its critical database on an Amazon RDS for PostgreSQL DB instance. The company wants to migrate to Amazon Aurora PostgreSQL with minimal downtime and data loss.Which solution will meet these requirements with the LEAST operational overhead?

Correct Answer: B. Create an Aurora read replica of the RDS for PostgreSQL DB instance. Promote the Aurora read replicate to a new Aurora PostgreSQL DB cluster.

Explanation

To migrate from an Amazon RDS for PostgreSQL DB instance to Amazon Aurora PostgreSQL with minimal downtime and data loss, the solution with the least operational overhead is:B. Create an Aurora read replica of the RDS for PostgreSQL DB instance. Promote the Aurora read replica to a new Aurora PostgreSQL DB cluster.Option B provides a solution that minimizes operational overhead while achieving the migration requirements:- Create an Aurora read replica: By creating an Aurora read replica of the RDS for PostgreSQL DB instance, you establish a real-time replica of the database. This allows for continuous replication of data from the RDS instance to the Aurora replica, minimizing downtime and data loss during the migration process.- Promote the Aurora read replica to a new Aurora PostgreSQL DB cluster: Once the Aurora read replica is fully caught up with the RDS instance, you can promote it to become the primary cluster. This process involves changing the DNS endpoint and updating the application configurations to point to the new Aurora cluster. By promoting the replica, you complete the migration with minimal downtime and data loss.Option A suggests creating a DB snapshot of the RDS for PostgreSQL DB instance to populate a new Aurora PostgreSQL DB cluster. While this option allows for data migration, it involves more operational steps, such as creating a snapshot, restoring it to an Aurora cluster, and configuring the necessary settings. This can introduce additional complexity and potential downtime during the migration process.Option C suggests using data import from Amazon S3 to migrate the database to an Aurora PostgreSQL DB cluster. While this approach allows for data migration, it requires exporting the data from the RDS instance, storing it in S3, and then importing it into the Aurora cluster. This introduces additional steps and potential complexities, resulting in higher operational overhead.Option D suggests using the pg_dump utility to back up the RDS for PostgreSQL database and restore the backup to a new Aurora PostgreSQL DB cluster. This approach requires manual backup and restore operations, which can be time-consuming and error-prone. It also involves additional steps and configuration changes, resulting in higher operational overhead.Therefore, the solution with the least operational overhead to migrate from an Amazon RDS for PostgreSQL DB instance to Amazon Aurora PostgreSQL is B: Create an Aurora read replica of the RDS for PostgreSQL DB instance and promote the Aurora read replica to a new Aurora PostgreSQL DB cluster. This approach ensures continuous replication, minimal downtime, and minimal data loss during the migration process.