AWS Certified SysOps Administrator – Associate (legacy) — Question 227

You receive a frantic call from a new DBA who accidentally dropped a table containing all your customers.
Which Amazon RDS feature will allow you to reliably restore your database to within 5 minutes of when the mistake was made?

Answer options

• A. Multi-AZ RDS
• B. RDS snapshots
• C. RDS read replicas
• D. RDS automated backup

Correct answer: D

Explanation

The RDS automated backup feature allows for point-in-time recovery of your database, enabling you to restore it to a specific moment, such as 5 minutes before the accidental deletion. Multi-AZ RDS provides high availability but does not offer point-in-time recovery, while RDS snapshots are manual and not as timely. RDS read replicas are used for scaling read operations and do not assist in restoring data.