AWS Certified Database – Specialty — Question 337

A large IT hardware manufacturing company wants to deploy a MySQL database solution in the AWS Cloud. The solution should quickly create copies of the company's production databases for test purposes. The solution must deploy the test databases in minutes, and the test data should match the latest production data as closely as possible. Developers must also be able to make changes in the test database and delete the instances afterward.
Which solution meets these requirements?

Answer options

• A. Leverage Amazon RDS for MySQL with write-enabled replicas running on Amazon EC2. Create the test copies using a mysqidump backup from the RDS for MySQL DB instances and importing them into the new EC2 instances.
• B. Leverage Amazon Aurora MySQL. Use database cloning to create multiple test copies of the production DB clusters.
• C. Leverage Amazon Aurora MySQL. Restore previous production DB instance snapshots into new test copies of Aurora MySQL DB clusters to allow them to make changes.
• D. Leverage Amazon RDS for MySQL. Use database cloning to create multiple developer copies of the production DB instance.

Correct answer: B

Explanation

Amazon Aurora database cloning allows for the rapid creation of writeable clones of a database cluster, which takes only a few minutes and uses minimal additional storage initially. Restoring from snapshots or using mysqldump takes significantly longer and does not meet the fast-deployment requirement. Furthermore, database cloning is a feature native to Amazon Aurora and is not supported in Amazon RDS for MySQL.