SAP-C02 Question 436
Select 3A company is running critical workloads on Amazon RDS for MySQL. The database must be protected against accidental deletion and must allow quick recovery in case of data corruption or loss. Which combination of strategies should you implement to meet these requirements?
- A
Enable automated backups for the RDS instance and configure a retention period.
- B
Take manual snapshots of the RDS instance periodically and store them in a separate AWS account.
- C
Enable Multi-AZ deployment for the RDS instance.
- D
Configure an S3 Lifecycle Policy to automatically delete RDS snapshots after 7 days.
- E
Enable deletion protection for the RDS instance.
Show answer and explanation
Correct answers: A, B, E
Explanation
To protect an RDS instance from accidental deletion and ensure quick recovery, you should implement multiple strategies: enabling automated backups for point-in-time recovery, taking manual snapshots for long-term, secure storage, and enabling deletion protection to prevent unintentional removal of the database. Multi-AZ deployment is important for availability but not relevant for backups, and lifecycle policies to delete snapshots can undermine data durability.
- A. Correct.
Enabling automated backups ensures that point-in-time recovery is possible, and setting a retention period determines how long backups are kept. This is essential for recovering from data corruption or loss.
- B. Correct.
Manual snapshots provide an additional layer of backup that can be stored securely, even in a separate AWS account for increased durability against accidental deletion.
- C. Incorrect.
While enabling Multi-AZ deployment improves high availability and failover capabilities, it does not provide a mechanism for backup or protection against accidental deletion.
- D. Incorrect.
Configuring an S3 Lifecycle Policy to delete RDS snapshots after 7 days may conflict with the backup retention requirements and increases the risk of losing critical data.
- E. Correct.
Enabling deletion protection ensures that the RDS instance cannot be accidentally deleted, which is a key requirement in this scenario.