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…

Question

Options

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

• A
  16% (8)
• B
  6% (3)
• C
  4% (2)
• D
  73% (36)

Explanation

AWS Backup is the most appropriate solution for managing backups with minimal operational overhead while meeting the regulatory requirement to retain data for 90 days and enabling point- in- time restore for up to 14 days. AWS Backup: AWS Backup provides a centralized backup management solution that supports automated backup scheduling, retention management, and compliance reporting across AWS services, including Amazon RDS. By creating a backup plan, you can define a retention period (in this case, 90 days) and automate the backup process. Point-in-Time Restore (PITR): Amazon RDS supports point-in-time restore for up to 35 days with automated backups. By using AWS Backup in conjunction with RDS, you ensure that your backup strategy meets the requirement for restoring data to a specific point in time within the last Why Not Other Options? Option A (RDS Automated Backups): While RDS automated backups support PITR, they do not directly support retention beyond 35 days without manual intervention. Option B (Manual Snapshots): Manually creating and managing snapshots is operationally intensive and less automated compared to AWS Backup. Option C (Aurora Clones): Aurora Clone is a feature specific to Amazon Aurora and is not applicable to Amazon RDS for Oracle.

No community discussion yet for this question.