AWS Certified Solutions Architect – Associate (SAA-C03) — Question 916

A company is migrating its on-premises Oracle database to an Amazon RDS for Oracle database. The company needs to retain data for 90 days to meet regulatory requirements. The company must also be able to restore the database to a specific point in time for up to 14 days.

Which solution will meet these requirements with the LEAST operational overhead?

Answer options

• A. Create Amazon RDS automated backups. Set the retention period to 90 days.
• B. Create an Amazon RDS manual snapshot every day. Delete manual snapshots that are older than 90 days.
• C. Use the Amazon Aurora Clone feature for Oracle to create a point-in-time restore. Delete clones that are older than 90 days.
• D. Create a backup plan that has a retention period of 90 days by using AWS Backup for Amazon RDS.

Correct answer: D

Explanation

AWS Backup for Amazon RDS provides a fully managed service to centralize and automate backups with a 90-day retention policy, which requires minimal operational effort. Amazon RDS automated backups alone cannot meet the 90-day requirement because they have a maximum retention limit of 35 days. Manual snapshots require custom scripting and maintenance, creating high operational overhead, while Amazon Aurora features are not applicable to Amazon RDS for Oracle.