Which feature should the solutions architect include in the design to meet this requirement?
Read replicas
Manual snapshots
Automated backups
Multi-AZ deployments
Explanations:
Read replicas are used primarily for scaling read operations and improving availability, but they do not provide the ability to restore to a specific point in time within a defined range. They do not inherently support point-in-time recovery (PITR) for data loss incidents.
Manual snapshots allow for the creation of backups at specific points in time, but they do not provide the ability to automatically recover the database to a specific point in time within the last 30 days without user intervention. They are not suitable for automatic recovery from changes made recently.
Automated backups enable point-in-time recovery (PITR) for Amazon RDS databases. This feature allows users to restore the database to any second within the backup retention period, which can be up to 35 days. This meets the requirement of restoring to a state from 5 minutes before any change within the last 30 days.
Multi-AZ deployments provide high availability and failover support, but they do not offer point-in-time recovery capabilities. They ensure redundancy and reliability, but they do not help in restoring to a previous state after data loss due to accidental changes.