A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The company must retain data for 90 days for regulatory reasons and be able to restore to any point in time for up to 14 days. Which solution meets these requirements with the LEAST operational overhead?
Choose an answer
Tap an option to check your answer.
Correct answer: Create a backup plan that has a retention period of 90 days by using AWS Backup for Amazon RDS..
Why this is the answer
The correct solution is to create a backup plan with a 90-day retention period using AWS Backup for Amazon RDS. AWS Backup provides a centralized, automated backup service that supports RDS, allowing you to define policies for retention and lifecycle management. This meets the 90-day data retention requirement with minimal operational overhead because AWS Backup handles the scheduling, creation, and deletion of backups automatically. The point-in-time restore for 14 days is inherently supported by RDS automated backups, which AWS Backup can manage. Creating Amazon RDS automated backups with a 90-day retention period is incorrect because RDS automated backup retention is limited to 35 days. Creating manual snapshots daily and deleting them manually is operationally intensive and prone to human error, failing the "least operational overhead" requirement. The Amazon Aurora Clone feature is for Aurora databases, not RDS for Oracle, and is used for creating new database instances from a specific point in time, not for managing long-term backups for regulatory compliance.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed