Q61Design Resilient Architectures
A company is moving its on-premises Oracle database to an Amazon RDS for Oracle database. The company must retain data for 90 days to satisfy regulatory requirements. The company must also be able to restore the database to a particular point in time for up to 14 days. Which solution meets these requirements with the **LEAST** operational overhead?
← → navigate · a answer
Community votes
Discussion · 6
D 8
Correct Answer is D - Its fulfilling the requirement of point in time.
Automated Backup - Default retention period is 0-35 Days - so option A is wrong.
D 5
A: Amazon RDS automated backups support a maximum retention period of 35 days. This option does not meet the requirement to retain backups for 90 days.
B: This approach requires manual snapshot management, including scheduling snapshots and deleting old ones. This increases operational overhead and is prone to human error.
C: This option is not applicable as Aurora Clone is a feature specific to Amazon Aurora and not available for Amazon RDS for Oracle. Additionally, it would require manual management of clones, increasing complexity.
D: AWS Backup supports point-in-time recovery for Amazon RDS, enabling you to restore the database to any specific point within the defined retention period, up to 35 days. For the requirement of 14 days, AWS Backup easily supports this capability.
D 3
https://aws.amazon.com/getting-started/hands-on/amazon-rds-backup-restore-using-aws-backup/
2
Answer is D
A 1
D - is not the best option: AWS Backup stores snapshots but does not manage transaction logs for PITR.
D 1
D is less work, so correct
A would be correct if was asking for cheaper option