Which solution will meet these requirements with the LEAST operational overhead?
Create Amazon RDS automated backups. Set the retention period to 90 days.
Create an Amazon RDS manual snapshot every day. Delete manual snapshots that are older than 90 days.
Use the Amazon Aurora Clone feature for Oracle to create a point-in-time restore. Delete clones that are older than 90 days.
Create a backup plan that has a retention period of 90 days by using AWS Backup for Amazon RDS.
Explanations:
Amazon RDS automated backups can retain data for up to 35 days, not 90 days. Therefore, this option does not meet the requirement of retaining data for 90 days.
While creating daily manual snapshots could retain data for 90 days, this method requires manual management of snapshots, increasing operational overhead. Additionally, the requirement for point-in-time recovery for up to 14 days is not directly addressed by this method.
The Amazon Aurora Clone feature is not applicable to Oracle databases in Amazon RDS. This option does not meet the requirement as it relies on a feature that is not available for Oracle on RDS.
AWS Backup allows for creating backup plans with custom retention periods, including 90 days. It also supports point-in-time recovery for Amazon RDS databases, thus meeting both the retention and restore requirements with minimal operational overhead.
I categorize that the answer is:
Create a backup plan that has a retention period of 90 days by using AWS Backup for Amazon RDS.