SOA-C02 Question 97
Select 2Your organization has a critical application running on Amazon EC2 instances with data stored in an Amazon RDS MySQL database. The organization requires a backup and restore strategy that ensures minimal data loss (RPO of 5 minutes) and quick recovery in case of accidental deletion. Which combination of actions should you take to meet these requirements?
- A
Enable automated backups for the Amazon RDS instance and set the backup retention period to 7 days.
- B
Create manual snapshots of the Amazon RDS instance daily and store them in Amazon S3.
- C
Enable Multi-AZ configuration for the Amazon RDS instance.
- D
Enable Amazon RDS point-in-time recovery and ensure transaction logs are retained for at least 7 days.
- E
Set up a regular schedule to back up Amazon EC2 instance volumes using Amazon Data Lifecycle Manager.
Show answer and explanation
Correct answers: A, D
Explanation
To meet the RPO of 5 minutes and ensure quick recovery, you must enable automated backups and point-in-time recovery for the RDS instance. Automated backups provide regular snapshots of the database, while point-in-time recovery allows you to restore the database to a specific point using transaction logs. Other options, such as manual snapshots or Multi-AZ, do not directly address the backup and restore requirements for this scenario.
- A. Correct.
Enabling automated backups and setting a backup retention period ensures regular backups are available for recovery. This is essential for meeting the RPO requirement.
- B. Incorrect.
Manual snapshots created daily might not meet the RPO of 5 minutes, as they are not frequent enough and require manual intervention.
- C. Incorrect.
While Multi-AZ configuration improves availability and durability, it is not a backup and restore strategy. It does not directly help with recovering from accidental deletion or meeting the RPO requirement.
- D. Correct.
Enabling point-in-time recovery ensures you can restore the database to a specific point within the retention period, meeting the RPO of 5 minutes.
- E. Incorrect.
Backing up EC2 instance volumes using Amazon Data Lifecycle Manager is not relevant to the RDS database backup and restore strategy.