SAP-C02 Question 95
Select 3A company runs a critical application on Amazon RDS for PostgreSQL with high availability enabled. The company’s compliance policy mandates that backups must be stored for at least 7 years and should remain accessible even in the event of accidental deletion of the database. As a Solutions Architect, how would you design the backup solution to meet these requirements?
- A
Enable RDS automated backups and set the backup retention period to 7 years.
- B
Create manual RDS snapshots periodically and copy them to an Amazon S3 bucket with versioning enabled.
- C
Enable Amazon S3 Object Lock in compliance mode for the S3 bucket where backups are stored.
- D
Use AWS Backup to create and manage backup policies for the RDS database and store backups in Amazon S3 with a defined retention period.
- E
Enable cross-region replication for the RDS database to ensure backups are available in another region.
Show answer and explanation
Correct answers: B, C, D
Explanation
To meet the requirements of 7-year retention and protection against accidental deletion, you need to use a combination of manual RDS snapshots stored in Amazon S3 and versioning to prevent accidental overwrites or deletions. Amazon S3 Object Lock in compliance mode ensures data is immutable for the retention period, further satisfying compliance needs. AWS Backup simplifies and automates the management of backup policies, offering a robust solution for long-term retention and recovery.
- A. Incorrect.
RDS automated backups cannot retain backups for more than 35 days, so this does not meet the 7-year retention requirement.
- B. Correct.
Manual RDS snapshots copied to an Amazon S3 bucket with versioning enabled address both the 7-year retention and protection against accidental deletion.
- C. Correct.
Amazon S3 Object Lock in compliance mode ensures that the backups cannot be modified or deleted during the retention period, making it suitable for compliance requirements.
- D. Correct.
AWS Backup provides centralized backup management and allows you to define retention policies, making it a suitable solution for long-term retention and compliance needs.
- E. Incorrect.
Cross-region replication ensures data availability in another region but does not inherently address the 7-year retention or accidental deletion requirements.