AWS Certified Database – Specialty — Question 218

A company uses an Amazon Aurora MySQL DB cluster. A database specialist has configured the DB cluster to use the automated backup feature with a 10-day retention period. The company wants the database specialist to reduce the cost of the database backup storage as much as possible without causing downtime. It is more important for the company to optimize costs than it is to retain a large set of database backups.

Which set of actions should the database specialist take on the DB cluster to meet these requirements?

Answer options

• A. Disable the automated backup feature by changing the backup retention period to 0 days. Perform manual snapshots daily. Delete old snapshots.
• B. Change the backup retention period to 1 day. Remove old manual snapshots if they are no longer required.
• C. Keep the backup retention period at 10 days. Remove old manual snapshots if they are no longer required.
• D. Disable the automated backup feature by changing the backup retention period to 0 days. Create a backup plan in AWS Backup to perform daily backups.

Correct answer: B

Explanation

The correct answer is B because changing the backup retention period to 1 day significantly reduces storage costs by minimizing the number of automated backups retained. Options A and D eliminate the automated backups entirely, which could lead to data loss, while option C maintains a longer retention period, which does not align with the goal of optimizing cost.