DBS-C01 · Question #266
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…
The correct answer is B. Leverage Amazon Aurora MySQL. Use database cloning to create multiple test copies of the. To quickly create multiple, independent test copies of a production MySQL database that reflect the latest data and allow developer modifications, Amazon Aurora MySQL's database cloning feature is the most suitable solution.
Question
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?
Options
- ALeverage Amazon RDS for MySQL with write-enabled replicas running on Amazon EC2. Create
- BLeverage Amazon Aurora MySQL. Use database cloning to create multiple test copies of the
- CLeverage Amazon Aurora MySQL. Restore previous production DB instance snapshots into new
- DLeverage Amazon RDS for MySQL. Use database cloning to create multiple developer copies of
How the community answered
(29 responses)- A7% (2)
- B76% (22)
- C14% (4)
- D3% (1)
Why each option
To quickly create multiple, independent test copies of a production MySQL database that reflect the latest data and allow developer modifications, Amazon Aurora MySQL's database cloning feature is the most suitable solution.
Amazon RDS for MySQL read replicas are read-only and cannot be written to, making them unsuitable for test environments where developers need to make changes. Setting up write-enabled replicas on EC2 is complex and not a native RDS feature for this purpose.
Amazon Aurora MySQL's database cloning feature allows creating a complete, writable copy of a database cluster in minutes, using a copy-on-write protocol for storage efficiency. This provides independent test environments that can be modified and deleted without impacting the source, directly meeting the requirements for speed, data freshness, and independent development.
Restoring an Aurora snapshot creates a new DB cluster, but this process typically takes longer than cloning and may not always provide the absolute latest data if the snapshot isn't extremely recent, making cloning a faster option for near real-time copies.
Amazon RDS for MySQL does not offer a native 'database cloning' feature that provides the same speed and storage efficiency as Amazon Aurora's cloning capability for creating fast, independent test environments.
Concept tested: Aurora database cloning for test environments
Source: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Managing.Clone.html
Topics
Community Discussion
No community discussion yet for this question.