SAP-C02 Question 94
Select 2A company uses Amazon RDS for a mission-critical production database. They require a robust backup and restore strategy to minimize downtime and prevent data loss in the event of a disaster. The company has the following requirements:
- Automated daily backups with a retention period of 7 days.
- The ability to perform point-in-time recovery (PITR) within the last 7 days.
- Ability to restore the database in a different AWS Region in case of a regional outage.
Which solution will meet these requirements?
- A
Enable automated backups for the RDS instance and set a retention period of 7 days.
- B
Enable RDS Multi-AZ deployment to ensure high availability and automatic failover.
- C
Enable RDS automated backups and configure cross-Region automated snapshots using AWS Backup.
- D
Manually create RDS snapshots daily and copy them to the target Region.
- E
Use AWS Database Migration Service (AWS DMS) to continuously replicate the database to another Region.
Show answer and explanation
Correct answers: A, C
Explanation
To meet the company’s requirements, enabling automated backups with a 7-day retention period addresses the need for PITR and daily backups. Configuring cross-Region automated snapshots using AWS Backup ensures backups are available in another Region for disaster recovery. While Multi-AZ deployment improves availability, it does not meet the cross-Region restore requirement, and manual or DMS-based solutions either lack automation or PITR capabilities.
- A. Correct.
Enabling automated backups with a 7-day retention period ensures daily snapshots and the ability to perform point-in-time recovery (PITR) for the last 7 days. This is required per the scenario.
- B. Incorrect.
Enabling RDS Multi-AZ deployment ensures high availability and automatic failover within the same Region but does not address cross-Region restore or backup requirements.
- C. Correct.
Enabling RDS automated backups and configuring cross-Region automated snapshots using AWS Backup ensures that backups are available in a different AWS Region, meeting the cross-Region restore requirement.
- D. Incorrect.
Manually creating snapshots and copying them to another Region is possible but not automated, which makes it error-prone and does not fully meet the company’s requirements for an automated solution.
- E. Incorrect.
Using AWS DMS for continuous replication is primarily for migration or replication purposes. It is not designed as a backup and restore solution, and it does not provide PITR capabilities.