Q56 — AWS SAA-C03 Ch.13

Question 56 of 100 | ← Chapter 13

Q956. 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?

• 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. Create a backup plan that has a retention period of 90 days by using AWS Backup for Amazon RDS

Explanation

The solution that meets the requirements with the LEAST operational overhead is D. Create a backup plan that has a retention period of 90 days by using AWS Backup for Amazon RDS.Here's why:Centralized Backup Management: AWS Backup provides a centralized service for managing backups across multiple AWS services, including Amazon RDS. This simplifies backup management and reduces operational overhead.Automated Backups: AWS Backup can automatically create backups according to a schedule, eliminating the need for manual intervention.Retention Policy: You can define a retention policy for backups, ensuring that data is retained for the required 90 days.Point-in-Time Restore: AWS Backup supports point-in-time restore, allowing you to restore the database to a specific point in time within the 14-day window.Why other options are less efficient:A. Create Amazon RDS automated backups. Set the retention period to 90 days: While RDS automated backups provide a convenient way to create backups, they don't offer the same level of flexibility and control as AWS Backup. You might need to manage backups manually if you need to restore to a specific point in time.B. Create an Amazon RDS manual snapshot every day. Delete manual snapshots that are older than 90 days: Manual snapshot creation and management require significant operational overhead, especially for daily backups.C. Use the Amazon Aurora Clone feature for Oracle to create a point-in-time restore. Delete clones that are older than 90 days: Aurora Clone is designed for Aurora databases, not for RDS for Oracle.In summary:Option D provides the most efficient and streamlined solution for meeting the company's backup and restore requirements. AWS Backup offers a centralized, automated, and policy-driven approach to backup management, reducing operational overhead and ensuring compliance with regulatory requirements.