Which Amazon RDS feature will allow you to reliably restore your database to within 5 minutes of when the mistake was made?
Multi-AZ RDS
RDS snapshots
RDS read replicas
RDS automated backup
Explanations:
Multi-AZ RDS provides high availability by replicating data across different Availability Zones. It is primarily used for failover in case of infrastructure failure, not for point-in-time recovery of accidentally dropped tables.
RDS snapshots are manual backups of your database, but they are not typically designed for point-in-time restoration. A snapshot may be outdated by the time you try to restore, and it can take longer than 5 minutes to restore.
RDS read replicas allow you to scale read traffic and create a replica of your database, but they are not intended for point-in-time recovery or restoring dropped tables quickly.
RDS automated backups include continuous backups and transaction logs, allowing you to restore your database to a specific point in time within the retention period (up to 35 days). This feature can restore the database to within 5 minutes of the mistake.