SOA-C02 Question 99
Single answerYour organization uses Amazon RDS for its production database. To comply with regulatory requirements, you need to implement a backup strategy that ensures point-in-time recovery for the last 7 days. Additionally, you want to minimize the operational effort required to manage this backup process. Which approach should you take to meet these requirements?
- A
Enable automated backups for the RDS instance and set the retention period to 7 days.
- B
Manually create daily snapshots of the RDS instance and delete snapshots older than 7 days.
- C
Use AWS Backup to create a backup plan for the RDS instance with a 7-day retention period.
- D
Use a cron job running on an EC2 instance to copy RDS logs to an S3 bucket and configure lifecycle rules to delete logs older than 7 days.
Show answer and explanation
Correct answer: A
Explanation
Enabling automated backups on Amazon RDS with a 7-day retention period is the most efficient and effective way to achieve point-in-time recovery while minimizing operational effort. This feature is fully managed by AWS, ensuring compliance with regulatory requirements for backup and restore strategies.
- A. Correct.
This is the correct answer. Enabling automated backups on Amazon RDS with a retention period of 7 days ensures point-in-time recovery and minimizes operational effort since the process is fully managed by AWS.
- B. Incorrect.
While creating manual snapshots can work, it requires significant manual effort to manage the snapshot lifecycle, making it less efficient than automated backups.
- C. Incorrect.
AWS Backup supports RDS in certain cases, but it does not provide point-in-time recovery. Therefore, AWS Backup alone does not meet the requirements of the scenario.
- D. Incorrect.
Copying RDS logs to S3 using a custom script does not satisfy the requirement of enabling point-in-time recovery. This approach also adds unnecessary operational overhead.