Which backup strategy allows restoring data in Autonomous Database as old as one year with a 10-day recovery point objective?

The option involving the use of automated backups is the correct choice because it directly aligns with the capabilities of Oracle's Autonomous Database services. Automated backups are designed to create snapshots of the database consistently, allowing users to restore data to a point in time within the defined retention period. In the case of Autonomous Database, the feature supports maintaining backups for up to one year.

Automated backups provide a recovery point objective (RPO) of 10 days, meaning if there is a need to restore the database, it can be done efficiently without manual intervention, ensuring that the procedure is smooth and quick. This automated process eliminates the risks associated with human error and guarantees regular and reliable backups.

Manual backups, whether taken weekly, monthly, or quarterly, do not offer the same efficiency and reliability. The ability to only restore data as far back as the last manual backup creates longer gaps in data recovery and can exceed the desired RPO. Therefore, relying solely on manual backups does not provide the same level of data protection or flexibility that automated backups do.