nerdexam
Amazon

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.

Submitted by paula_co· Mar 6, 2026Deployment and Migration

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)
  • A
    7% (2)
  • B
    76% (22)
  • C
    14% (4)
  • D
    3% (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.

ALeverage Amazon RDS for MySQL with write-enabled replicas running on Amazon EC2. Create

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.

BLeverage Amazon Aurora MySQL. Use database cloning to create multiple test copies of theCorrect

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.

CLeverage Amazon Aurora MySQL. Restore previous production DB instance snapshots into new

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.

DLeverage Amazon RDS for MySQL. Use database cloning to create multiple developer copies of

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

#Aurora MySQL#database cloning#test environments#development workflow

Community Discussion

No community discussion yet for this question.

Full DBS-C01 Practice