Exam AWS Certified Database - Specialty topic 1 question 240 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 240
Topic #: 1

[All AWS Certified Database - Specialty Questions]

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?

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.

Show Suggested Answer

Suggested Answer: B 🗳️

by mbar94 at Sept. 7, 2022, 11:13 a.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

Pranava_GCP

1 year, 9 months ago

Selected Answer: B

B. Amazon Aurora MySQL, database cloning

upvoted 1 times

...

Pranava_GCP

1 year, 9 months ago

B. Amazon Aurora MySQL, database cloning https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Managing.Clone.html "Aurora cloning is especially useful for quickly setting up test environments using your production data, without risking data corruption. You can use clones for many types of applications, such as the following: Experiment with potential changes (schema changes and parameter group changes, for example) to assess all impacts. Run workload-intensive operations, such as exporting data or running analytical queries on the clone. Create a copy of your production DB cluster for development, testing, or other purposes."

upvoted 2 times

...

SonamDhingra

2 years, 8 months ago

Selected Answer: B

B is correct

upvoted 1 times

...

mbar94

2 years, 9 months ago

Selected Answer: B

Quick and easy deploy - Aurora with cloning feature. It's B.

upvoted 4 times

...