exam questions

Exam AWS Certified Database - Specialty All Questions

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

Exam AWS Certified Database - Specialty topic 1 question 122 discussion

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

A company recently acquired a new business. A database specialist must migrate an unencrypted 12 TB Amazon RDS for MySQL DB instance to a new AWS account. The database specialist needs to minimize the amount of time required to migrate the database.
Which solution meets these requirements?

  • A. Create a snapshot of the source DB instance in the source account. Share the snapshot with the destination account. In the target account, create a DB instance from the snapshot.
  • B. Use AWS Resource Access Manager to share the source DB instance with the destination account. Create a DB instance in the destination account using the shared resource.
  • C. Create a read replica of the DB instance. Give the destination account access to the read replica. In the destination account, create a snapshot of the shared read replica and provision a new RDS for MySQL DB instance.
  • D. Use mysqldump to back up the source database. Create an RDS for MySQL DB instance in the destination account. Use the mysql command to restore the backup in the destination database.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

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
Zhongkai
Highly Voted 3 years, 8 months ago
Sharing an unencrypted manual DB snapshot enables authorized AWS accounts to directly restore a DB instance from the snapshot instead of taking a copy of it and restoring from that. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ShareSnapshot.html However Resource Access Manager could not share non-Aurora cluster. https://docs.aws.amazon.com/ram/latest/userguide/shareable.html Hence I will go with A.
upvoted 10 times
...
sachin
Most Recent 2 years, 11 months ago
A is correct.
upvoted 1 times
...
novice_expert
3 years, 1 month ago
Selected Answer: A
create snapshot -> share with destination account -> copy -> create instance from snapshot
upvoted 1 times
...
Dantas
3 years, 2 months ago
Selected Answer: A
A -> The database professional must keep the migration time to a minimum.
upvoted 1 times
...
RotterDam
3 years, 3 months ago
Selected Answer: A
A but the answer choice is insufficient. With just this you will see a downtime. You need binlog replication for minimal downtime (or DMS)
upvoted 3 times
...
user0001
3 years, 3 months ago
Selected Answer: A
answer a
upvoted 1 times
...
Shunpin
3 years, 5 months ago
Ans: A Mysqldump is too slow. If mysqlpump, I might consider this.
upvoted 3 times
...
toppic26
3 years, 6 months ago
12 TB dump meaningless and slow, then you need to share? Answer is A.
upvoted 1 times
...
ChauPhan
3 years, 7 months ago
A and D both are both but I think A is faster than D. mysqldump for 12T data is nearly impossible.
upvoted 3 times
...
Aesthet
3 years, 7 months ago
A final answer
upvoted 3 times
...
AM
3 years, 8 months ago
B looks good to me. Criteria is minimize migration time. 12TB snapshot will also take time.
upvoted 1 times
...
manan728
3 years, 8 months ago
A is correct even though it is missing a crucial step of copying the snapshot in the target account. Simply sharing isn't sufficient.
upvoted 2 times
...
shantest1
3 years, 8 months ago
A. snapshot is faster than the backup. A appears to be the answer.
upvoted 4 times
...
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
Loading ...