AWS Certified Database – Specialty – Question194

A company's applications store data in Amazon Aurora MySQL DB clusters. The company has separate AWS accounts for its production, test, and development environments. To test new functionality in the test environment, the company's development team requires a copy of the production database four times a day.
Which solution meets this requirement with the MOST operational efficiency?

A.
Take a manual snapshot in the production account. Share the snapshot with the test account. Restore the database from the snapshot.
B. Take a manual snapshot in the production account. Export the snapshot to Amazon S3. Copy the snapshot to an S3 bucket in the test account. Restore the database from the snapshot.
C. Share the Aurora DB cluster with the test account. Create a snapshot of the production database in the test account. Restore the database from the snapshot.
D. Share the Aurora DB cluster with the test account. Create a clone of the production database in the test account.

Correct Answer: D

Explanation:

Explanation:
Creating and restoring a database snapshot. You can create a clone of one of your Aurora DB clusters and share the clone.
Reference: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora…