SAA-C03 Question 77
Select 3Your company runs a critical web application on Amazon EC2 instances with an Amazon RDS MySQL database in the backend. Recently, there was an accidental deletion of some database tables, causing significant disruption. To prevent data loss in the future, you are tasked with designing a solution to ensure the ability to quickly recover from similar incidents. What should you do to meet this requirement?
- A
Enable automated backups for the Amazon RDS database.
- B
Take manual snapshots of the Amazon RDS database on a regular basis.
- C
Configure multi-AZ deployment for the Amazon RDS database.
- D
Enable point-in-time recovery for the Amazon RDS database.
- E
Use Amazon S3 to store periodic exports of the database using the mysqldump utility.
Show answer and explanation
Correct answers: A, B, D
Explanation
To ensure data recovery for an Amazon RDS database, enabling automated backups and point-in-time recovery are critical as they allow you to restore the database to a state before any accidental deletion. Manual snapshots provide an additional backup option for specific points in time. Multi-AZ deployment does not address recovery from logical errors, and while exporting data to Amazon S3 may assist in long-term storage, it is not the most effective solution for immediate recovery scenarios.
- A. Correct.
Enabling automated backups allows Amazon RDS to automatically create daily backups and transaction logs for point-in-time recovery, which can help restore the database to a specific time before the accidental deletion.
- B. Correct.
Manual snapshots are user-initiated backups and provide an additional layer of control in preserving specific database states. This can be used to recover the database if tables are accidentally deleted.
- C. Incorrect.
Multi-AZ deployment improves availability and fault tolerance by creating a standby replica in another availability zone, but it does not protect against logical errors like accidental deletion of data.
- D. Correct.
Point-in-time recovery allows you to restore the database to a specific time before the accidental deletion occurred, provided automated backups are enabled.
- E. Incorrect.
Using Amazon S3 to store database exports with mysqldump can be useful for archival purposes, but it is not as efficient or seamless as automated backups or point-in-time recovery for immediate restoration in case of accidental deletion.