SOA-C02 Question 98
Select 2Your company uses an Amazon RDS MySQL database for a critical production workload. You need to ensure that the database can be restored to any point in time within the last 7 days in case of accidental deletion or data corruption. Which combination of actions should you take to implement this backup and restore strategy?
- A
Enable automated backups for the RDS instance and specify a 7-day retention period.
- B
Manually create on-demand snapshots of the RDS instance every 7 days.
- C
Enable Multi-AZ replication for the RDS instance to ensure high availability.
- D
Configure point-in-time recovery by enabling binary logging on the RDS instance.
- E
Set up an AWS Backup plan with a 7-day retention policy for the RDS instance.
Show answer and explanation
Correct answers: A, D
Explanation
To implement a backup and restore strategy that allows point-in-time recovery for an Amazon RDS MySQL database, you must enable automated backups with a sufficient retention period and configure binary logging. Automated backups provide daily snapshots and transaction logs, while binary logging ensures that changes to the database are captured, enabling point-in-time recovery within the retention period.
- A. Correct.
Correct. Enabling automated backups and specifying a 7-day retention period ensures that backups are taken daily and retained for the required timeframe. This is essential for point-in-time recovery.
- B. Incorrect.
Incorrect. While manual snapshots can be useful for certain use cases, they are not a substitute for automated backups and do not allow point-in-time recovery.
- C. Incorrect.
Incorrect. Multi-AZ replication ensures high availability and failover capabilities but does not provide backup functionality or point-in-time recovery.
- D. Correct.
Correct. Enabling binary logging is a prerequisite for point-in-time recovery for RDS MySQL databases. This allows AWS to capture changes made to the database and restore to a specific point in time.
- E. Incorrect.
Incorrect. AWS Backup can be used to back up RDS instances, but it does not support point-in-time recovery. Automated backups with a retention period are more appropriate for this use case.