SAA-C03 Question 76
Single answerA company runs a critical application on Amazon RDS for MySQL and needs to ensure that they can quickly recover their data in case of accidental deletion or corruption. Which approach provides the most effective solution for data recovery?
- A
Enable RDS automated backups and perform manual snapshots periodically.
- B
Replicate the RDS database to another region using AWS Database Migration Service (DMS).
- C
Enable Multi-AZ deployment for the RDS instance to automatically failover in case of data corruption.
- D
Use Amazon RDS read replicas to create point-in-time recovery backups.
Show answer and explanation
Correct answer: A
Explanation
The most effective solution for data recovery in this scenario is to enable RDS automated backups, which allow point-in-time recovery to restore the database to a specific state before accidental deletion or corruption. Manual snapshots provide an additional layer of protection by allowing the user to create backups at specific times.
- A. Correct.
This is the correct answer. Enabling automated backups ensures point-in-time recovery, while manual snapshots provide additional recovery options in case of accidental deletion or corruption.
- B. Incorrect.
While replicating data to another region using AWS DMS can provide disaster recovery for regional failures, it does not provide point-in-time recovery for accidental deletion or corruption.
- C. Incorrect.
Multi-AZ deployment improves availability and failover in case of infrastructure failure but does not help recover from data corruption or accidental deletion.
- D. Incorrect.
Read replicas are used for read scalability and cannot be used for point-in-time backups or recovery.