SAA-C03 Question 403
Single answerA company needs to back up its Amazon RDS database to ensure minimal data loss in the event of a failure. They require point-in-time recovery for up to 7 days and want to automate the backup process. What is the most cost-effective backup strategy to achieve this?
- A
Enable automated backups for the RDS instance.
- B
Create manual snapshots of the RDS instance daily.
- C
Set up Amazon S3 Lifecycle Policies to archive the backups.
- D
Use AWS Backup to schedule daily backups for the RDS instance.
Show answer and explanation
Correct answer: A
Explanation
Enabling automated backups on an Amazon RDS instance is the most cost-effective and straightforward solution for providing daily backups and point-in-time recovery capabilities. Automated backups store snapshots and transaction logs, ensuring that data can be restored to any point in time within the retention period, which aligns perfectly with the company's requirements.
- A. Correct.
Enabling automated backups for an RDS instance provides daily snapshots and transaction logs that allow point-in-time recovery. It is the most cost-effective and automated solution for this scenario.
- B. Incorrect.
While manual snapshots can be used to back up the database, they require manual intervention or additional configuration, making them less automated and potentially less cost-effective.
- C. Incorrect.
Amazon S3 Lifecycle Policies are used for managing object storage in Amazon S3, not for creating or managing RDS backups.
- D. Incorrect.
AWS Backup can manage RDS backups, but enabling automated backups directly on the RDS instance is simpler, more integrated, and avoids the additional configuration required with AWS Backup.