SAA-C03 Question 402
Select 3A company runs a critical e-commerce application on Amazon RDS for PostgreSQL. To ensure the application's data can be quickly recovered in case of accidental deletion or a regional disaster, they want to implement a backup strategy. Which of the following are appropriate actions to meet their requirements?
- A
Enable automated backups for the RDS instance and configure a backup retention period.
- B
Set up an RDS Read Replica in another AWS Region and enable backups on the replica.
- C
Regularly export RDS snapshots to Amazon S3 and replicate the data to another AWS Region.
- D
Use AWS Backup to take application-consistent backups of the RDS database.
- E
Enable Multi-AZ on the RDS instance to ensure data durability.
Show answer and explanation
Correct answers: A, C, D
Explanation
To implement a robust backup strategy for Amazon RDS for PostgreSQL, it is essential to enable automated backups for point-in-time recovery and protect against regional disasters by exporting snapshots to another region or using AWS Backup for cross-region backup capabilities. Multi-AZ primarily addresses high availability within the same region and is not a substitute for backups.
- A. Correct.
This is a valid option. Automated backups allow you to recover the database to any point within the retention period, but they are stored in the same region as the RDS instance. While this helps with accidental data deletion, it does not address regional disasters.
- B. Incorrect.
While Read Replicas can be set up in another region, enabling backups on a Read Replica is not supported. Read Replicas are primarily used for offloading read traffic and enhancing performance, not for backup purposes.
- C. Correct.
Exporting RDS snapshots to Amazon S3 and replicating the data to another region provides a disaster recovery solution, as it protects against regional failures and ensures data is available in a different region.
- D. Correct.
AWS Backup supports RDS and provides application-consistent backups, which are useful for ensuring recoverable backups for your database workloads. It also allows for cross-region backup capabilities.
- E. Incorrect.
Enabling Multi-AZ ensures high availability and durability within the same region by creating a synchronous standby replica, but it does not protect against regional disasters or accidental data deletion.