SAP-C02 Question 93
Select 3A company uses Amazon RDS for their production database. They want to ensure minimal downtime and data loss in case of accidental deletion or corruption of data. The company requires a robust data backup and restoration strategy. Which of the following solutions would best meet their requirements?
- A
Enable automated backups for the RDS instance and configure a suitable backup retention period.
- B
Take manual snapshots of the RDS instance before making any critical changes.
- C
Enable Multi-AZ deployment for the RDS instance to ensure high availability.
- D
Implement cross-Region read replicas to have a disaster recovery option.
- E
Use AWS Backup to create additional scheduled backups of the RDS instance.
Show answer and explanation
Correct answers: A, B, E
Explanation
To meet the company's requirements of minimal downtime and data loss, a robust backup and restoration strategy should include automated backups for point-in-time recovery, manual snapshots for critical changes, and additional scheduled backups via AWS Backup for enhanced protection. While features like Multi-AZ and cross-Region read replicas are beneficial for high availability and disaster recovery, they do not directly address backup and restoration needs for accidental deletion or corruption.
- A. Correct.
Enabling automated backups is critical for ensuring point-in-time recovery of the database in case of accidental deletion or corruption. Configuring a suitable retention period ensures the backups are retained for the required duration.
- B. Correct.
Taking manual snapshots before critical changes provides an additional layer of protection by creating a specific, custom recovery point. This is particularly useful when automated backups might not align with the timing of these changes.
- C. Incorrect.
While enabling Multi-AZ deployment ensures high availability and failover support, it does not directly address backup and restoration requirements for accidental data loss or corruption.
- D. Incorrect.
Cross-Region read replicas provide disaster recovery options but are primarily designed for read scalability and geographic redundancy, not for backup and restoration purposes.
- E. Correct.
AWS Backup allows centralized and scheduled management of backups for RDS instances, providing an additional layer of scheduled, automated backups beyond the default RDS backup features.