Topic 1 Question 601

AWS Certified Solutions Architect - Associate

Topic 1 Question 601
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?
- Create a DB snapshot of the RDS for PostgreSQL DB instance to populate a new Aurora PostgreSQL DB cluster.
- Create an Aurora read replica of the RDS for PostgreSQL DB instance. Promote the Aurora read replicate to a new Aurora PostgreSQL DB cluster.
- Use data import from Amazon S3 to migrate the database to an Aurora PostgreSQL DB cluster.
- Use the pg_dump utility to back up the RDS for PostgreSQL database. Restore the backup to a new Aurora PostgreSQL DB cluster.
ユーザの投票
コメント(12)
- 正解だと思う選択肢: B
  The key reasons are:
  
  Aurora read replicas allow setting up replication from RDS PostgreSQL to Aurora PostgreSQL with minimal downtime. Once replication is set up, the read replica can be promoted to a full standalone Aurora DB cluster with little to no downtime. This approach leverages AWS's managed replication between the source RDS PostgreSQL instance and Aurora. It avoids having to manually create backups and restore data. Using DB snapshots or pg_dump backups requires manually restoring data which increases downtime and operational overhead. Data import from S3 would require exporting, uploading and then importing data which adds overhead.
  
  👍 4
  Guru4Cloud2023/09/23
- Answer [B]
  
  There are five options for migrating data from your existing Amazon RDS for PostgreSQL database to an Amazon Aurora PostgreSQL-Compatible DB cluster. 1-Using a snapshot 2-Using an Aurora read replica 3-Using a pg_dump utility 4-Using logical replication 5-Using a data import from Amazon S3
  
  (2-Using an Aurora read replica) The Aurora read replica option minimizes downtime during a migration. Which is what the question demand so answer B; is the correct ; https://repost.aws/knowledge-center/aurora-postgresql-migrate-from-rds
  
  👍 3
  Sugarbear_012023/09/23
- B is correct guys. Lets see what we got here: C and D is not correct of course. We have to consider A and B. A: migration using a snapshot: this would, of course, introduce heavy data loss and down time B: migration using read replica: nearly no dataloss and downtime.
  
  👍 3
  thanhnv1422023/10/22
シャッフルモード

ユーザの投票

コメント(12)