Question

A SysOps administrator manages a production Amazon RDS for PostgreSQL database (Single-AZ) with automated backups enabled and a 7-day retention period. At 14:32, a developer runs an incorrect script that deletes several critical tables. The team discovers the problem at 15:10 and needs to restore the data to the state it was in just before the deletion, while minimizing downtime for the running instance. What is the MOST appropriate action?

Accepted Answer

Perform a point-in-time recovery to a new DB instance using a target time of 14:31, then redirect the application to the new instance.

Answer

Restore the most recent automated snapshot directly over the existing DB instance to overwrite the deleted tables.

Answer

Enable Multi-AZ on the existing instance so the standby replica can serve the data that existed before 14:32.

Answer

Create a read replica of the current instance and promote it to recover the deleted tables.