Question

A CloudOps engineer manages a production Amazon RDS for PostgreSQL database that supports an order-processing application. The business requires the ability to recover the database to any specific second within the last 5 days in case of accidental data corruption from a bad application deployment. The team currently relies only on daily automated snapshots taken at 2 AM. During a recent incident, a faulty batch job corrupted data at 3 PM, and the team could only restore to the previous night's snapshot, losing 13 hours of transactions. Which action best meets the recovery requirement going forward?

Accepted Answer

Ensure automated backups are enabled with a 5-day retention period and use point-in-time recovery (PITR) to restore to a specific timestamp.

Answer

Increase the automated snapshot frequency to run every hour using an AWS Backup scheduled plan.

Answer

Enable a Multi-AZ deployment so the standby replica can be promoted to the exact moment before corruption.

Answer

Create a cross-Region read replica and promote it to recover data from before the corruption event.