SAP-C02 Question 91
Single answerA company runs a critical application on Amazon RDS using an Aurora PostgreSQL cluster. The company must ensure that it can recover data to within 5 minutes of a failure and must minimize the cost of backups. Which solution meets these requirements?
- A
Enable automated backups and set the backup retention period to 35 days.
- B
Enable continuous backup with Amazon RDS and use point-in-time recovery.
- C
Manually create database snapshots every 5 minutes.
- D
Configure an AWS Backup plan with a 5-minute backup frequency.
Show answer and explanation
Correct answer: B
Explanation
The best solution is to enable continuous backup with Amazon RDS and use point-in-time recovery. This allows the database to be restored to a specific point in time within the backup retention period, meeting the required recovery point objective of 5 minutes while minimizing costs compared to frequent manual snapshots or overly complex configurations.
- A. Incorrect.
While enabling automated backups is recommended, this only provides backups at a daily frequency, which does not meet the 5-minute recovery point objective (RPO) requirement.
- B. Correct.
Enabling continuous backup with Amazon RDS and using point-in-time recovery allows the database to be restored to any specific time within the retention period, meeting the 5-minute RPO requirement. This is also cost-efficient since it avoids the need for frequent manual snapshots.
- C. Incorrect.
Manually creating snapshots every 5 minutes is impractical and costly. Additionally, it introduces unnecessary operational overhead and increases the chances of human error.
- D. Incorrect.
AWS Backup does not support a 5-minute backup frequency. The minimum backup interval supported by AWS Backup is 1 hour, which fails to meet the 5-minute RPO requirement.