Exam AWS Certified Database - Specialty topic 1 question 27 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 27
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company is about to launch a new product, and test databases must be re-created from production data. The company runs its production databases on an
Amazon Aurora MySQL DB cluster. A Database Specialist needs to deploy a solution to create these test databases as quickly as possible with the least amount of administrative effort.
What should the Database Specialist do to meet these requirements?

A. Restore a snapshot from the production cluster into test clusters
B. Create logical dumps of the production cluster and restore them into new test clusters
C. Use database cloning to create clones of the production cluster
D. Add an additional read replica to the production cluster and use that node for testing

Show Suggested Answer

Suggested Answer: C 🗳️

by [deleted] at July 12, 2020, 7:11 p.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

Submit Cancel

BillyMadison

Highly Voted 3 years, 10 months ago

C. https://aws.amazon.com/getting-started/hands-on/aurora-cloning-backtracking/ "Cloning an Aurora cluster is extremely useful if you want to assess the impact of changes to your database, or if you need to perform workload-intensive operations—such as exporting data or running analytical queries, or simply if you want to use a copy of your production database in a development or testing environment. You can make multiple clones of your Aurora DB cluster. You can even create additional clones from other clones, with the constraint that the clone databases must be created in the same region as the source databases.

upvoted 17 times

...

IhorK

Most Recent 2 years ago

Selected Answer: C

When we do cloning, there is no physical overwriting of data to a new location, only meta-data is copied. Therefore, the cloning process is quite fast. However, further changes are isolated from each other in source and clone.

upvoted 1 times

...

ken_test1234

2 years, 4 months ago

Selected Answer: C

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Managing.Clone.html

upvoted 1 times

...

f___16

2 years, 5 months ago

Selected Answer: C

Cloning is the best choice. It creates a new db cluster with the same data.

upvoted 1 times

...

Jiang_aws1

2 years, 10 months ago

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Managing.Clone.html Creating a clone is faster and more space-efficient than physically copying the data using other techniques, such as restoring a snapshot.

upvoted 2 times

...

novice_expert

3 years, 3 months ago

Selected Answer: C

C. Use database cloning to create clones of the production cluster Cloning is best choice with "copy-on-write" protocol, database becomes available in a few mins. https://aws.amazon.com/getting-started/hands-on/aurora-cloning-backtracking/ "Cloning an Aurora cluster is extremely useful if you want to assess the impact of changes to your database, or if you need to perform workload-intensive operations—such as exporting data or running analytical queries, or simply if you want to use a copy of your production database in a development or testing environment. You can make multiple clones of your Aurora DB cluster. You can even create additional clones from other clones, with the constraint that the clone databases must be created in the same region as the source databases.

upvoted 2 times

...