AWS Certified Database – Specialty — Question 322

A development team asks a database specialist to create a copy of a production Amazon RDS for MySQL DB instance every morning. The development team will use the copied DB instance as a testing environment for development. The original DB instance and the copy will be hosted in different VPCs of the same AWS account. The development team wants the copy to be available by 6 AM each day and wants to use the same endpoint address each day.
Which combination of steps should the database specialist take to meet these requirements MOST cost-effectively? (Choose three.)

Answer options

• A. Create a snapshot of the production database each day before the 6 AM deadline.
• B. Create an RDS for MySQL DB instance from the snapshot. Select the desired DB instance size.
• C. Update a defined Amazon Route 53 CNAME record to point to the copied DB instance.
• D. Set up an AWS Database Migration Service (AWS DMS) migration task to copy the snapshot to the copied DB instance.
• E. Use the CopySnapshot action on the production DB instance to create a snapshot before 6 AM.
• F. Update a defined Amazon Route 53 alias record to point to the copied DB instance.

Correct answer: A, B, C

Explanation

To achieve this cost-effectively, a daily snapshot of the production Amazon RDS DB instance must be taken and then restored into the development VPC as a new DB instance. Since restoring a snapshot generates a new endpoint each time, a Route 53 CNAME record must be updated daily to ensure the developers can use a consistent endpoint address. Route 53 alias records cannot point directly to RDS instances, and using AWS DMS or CopySnapshot is unnecessary and adds extra costs for same-account, same-region snapshot restorations.