ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 23 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 23
Topic #: 1
[All AWS Certified Database - Specialty Questions]

A company is running its line of business application on AWS, which uses Amazon RDS for MySQL at the persistent data store. The company wants to minimize downtime when it migrates the database to Amazon Aurora.
Which migration method should a Database Specialist use?

  • A. Take a snapshot of the RDS for MySQL DB instance and create a new Aurora DB cluster with the option to migrate snapshots.
  • B. Make a backup of the RDS for MySQL DB instance using the mysqldump utility, create a new Aurora DB cluster, and restore the backup.
  • C. Create an Aurora Replica from the RDS for MySQL DB instance and promote the Aurora DB cluster.
  • D. Create a clone of the RDS for MySQL DB instance and promote the Aurora DB cluster.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by chicagomassageseeker at July 13, 2020, 8:24 a.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
chicagomassageseeker
Highly Voted 3 years, 8 months ago
Answer C. Minimal Downtime with Aurora replica. However this is not the fastest.
upvoted 12 times
BillyMadison
3 years, 8 months ago
Agree C. This blogpost explains why C is the answer since read replicas reduce downtime. https://aws.amazon.com/blogs/database/best-practices-for-migrating-rds-for-mysql-databases-to-amazon-aurora/
upvoted 13 times
...
...
Pranava_GCP
Most Recent 1 year, 8 months ago
Selected Answer: C
C. Create an Aurora Replica from the RDS for MySQL DB instance and promote the Aurora DB cluster. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Migrating.RDSMySQL.Replica.html
upvoted 1 times
...
f___16
2 years, 1 month ago
Selected Answer: C
When migrating from RDS Mysql/Postgres to Aurora, easiest and most effortless way is to take an (aurora replica and then promote it to standalone). answer is C.
upvoted 1 times
...
ken_test1234
2 years, 2 months ago
Selected Answer: C
This article from aws show you that C is exactly the answer https://aws.amazon.com/getting-started/hands-on/migrate-rdsmysql-to-auroramysql/
upvoted 1 times
...
Mintwater
2 years, 2 months ago
C. Please refer below --- https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Migrating.RDSMySQL.Replica.html " You can migrate from an RDS for MySQL DB instance by first creating an Aurora MySQL read replica of a MySQL DB instance. When the replica lag between the MySQL DB instance and the Aurora MySQL read replica is 0, you can direct your client applications to read from the Aurora read replica and then stop replication to make the Aurora MySQL read replica a standalone Aurora MySQL DB cluster for reading and writing. For details, see Migrating data from a MySQL DB instance to an Amazon Aurora MySQL DB cluster by using an Aurora read replica. "
upvoted 1 times
...
Anmol_1401
2 years, 4 months ago
Selected Answer: C
C is the Answer as per cloud guru. Key is minimal downtime
upvoted 2 times
...
awsguys
3 years ago
C => right as minimize downtime.
upvoted 1 times
...
novice_expert
3 years, 1 month ago
Selected Answer: C
MySQL DB instance -> Create an Aurora Replica ( will take time) -> promote the Aurora DB cluster (Minimal downtime)
upvoted 1 times
...
jove
3 years, 5 months ago
Answer is option C .. Minimal downtime.
upvoted 1 times
...
GMartinelli
3 years, 6 months ago
Selected Answer: C
Option C
upvoted 3 times
...
guru_ji
3 years, 7 months ago
Correct Answer ==>> C
upvoted 2 times
...
gelsm
3 years, 7 months ago
C. Create an Aurora Replica from the RDS for MySQL DB instance and promote the Aurora DB cluster. This may not be the fastest but the question is "minimize downtime".
upvoted 1 times
...
LMax
3 years, 7 months ago
I go with C
upvoted 1 times
...
myutran
3 years, 7 months ago
Ans: C
upvoted 1 times
...
GeeBeeEl
3 years, 7 months ago
The answer is A and I will prove it --- please follow with me carefully There is a requirement for minimal downtime (FASTEST) --- I go with A https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Migrating.html#AuroraPostgreSQL.Migrating.RDSPostgreSQL.Import.Console According to that link “Be prepared for migration to take a while, roughly several hours per tebibyte (TiB) of data.” if you go with C. C will thus lead to a longer downtime while A will not
upvoted 2 times
imatowel
3 years, 7 months ago
Ok, so what about data written to source RDS after snapshop but before swap to Aurora? You loose data that's unacceptable
upvoted 1 times
...
Dip11
3 years, 7 months ago
You need to understand the difference between minimal downtime and Fastest. Both are not same. Answer is C.
upvoted 1 times
...
...
JobinAkaJoe
3 years, 8 months ago
C because it facilitates migration to aurora with least down-time.
upvoted 2 times
...
waterh30
3 years, 8 months ago
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Migrating.html#AuroraPostgreSQL.Migrating.RDSPostgreSQL.Replica
upvoted 1 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel