Exam AWS Certified Database - Specialty topic 1 question 9 discussion

D. While C would work, the requirement is minimal downtime. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Migrating.html

D. Migrate data from the RDS for PostgreSQL DB instance to an Aurora PostgreSQL DB cluster using an Aurora Replica. Promote the replica during the cutover. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Migrating.html#AuroraPostgreSQL.Migrating.RDSPostgreSQL.Replica

D Migrating from RDS PostgreSQL to Aurora PostgreSQL. You have two options when migrating data from RDS PostgreSQL to Aurora PostgreSQL: - Use an RDS PostgreSQL snapshot - Use an Aurora Read Replica for RDS PostgreSQL https://aws.amazon.com/blogs/database/migrate-to-an-amazon-aurora-postgresql-instance-from-another-postgresql-source/

The correct answer is D. The keyword is "FASTEST" ~ minimal downtime / minimal effort "You can migrate your existing Amazon RDS MySQL databases to Amazon Aurora using Aurora Read Replica. This solution is beneficial since it's completely managed and does not involve manually configuring replication functionality to reduce downtime during migration." "PostgreSQL follows the same process as the one described previously for MySQL for migration." https://docs.aws.amazon.com/whitepapers/latest/migrating-databases-to-amazon-aurora/migration-using-aurora-read-replica.html

Author from the Udemy.com practice test says D is the correct answer.

D is the right option

C - snapshot will take time (and new transactions lost) D- Replica is fast

D is absolutely correct

We need the SPEEDIEST solution, however, we also need a reasonable solution; how would we deal with database changes when restoring the database when we pick B? AWS perform that job for us when choosing D.

Keywords : seamless and speediest.. Answer : Option D

Option D

D: because in question talking about minimum downtime .

D is the correct answer, Read Replica is faster than snapshots

D ==>> Correct Answer.

if we say C is fastest then how to handle changes to source server while snapshot is being transferred and getting applied to target ?

Answer D

Answer D. When you take a snapshot there will be a temporary suspension of I/O Services, now this can be seconds or longer, but our size is 1TB which means that there will be downtime, so based on that the answer is D