AWS Certified Database – Specialty — Question 20

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?

Answer options

• 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

Correct answer: C

Explanation

The correct answer is C because database cloning allows for the rapid creation of test databases directly from the production environment with minimal administrative overhead. Options A and B involve more time-consuming processes like restoring snapshots and creating logical dumps, while option D does not create separate test databases and merely adds a read replica, which is not ideal for testing.