AWS Interview DropIntermediate TierScenario+25 XP on read
Design a backup and recovery strategy for a production RDS database, including what point-in-time recovery can and can't actually do for you.
Core Summary
Automated backups and point-in-time recovery cover the everyday case, restoring to any second within the retention window, but every restore creates a brand-new instance rather than repairing the existing one, and neither protects against a whole-region outage on its own. Cross-region snapshot copies and manual snapshots fill the two gaps that leaves.
Hints
Hint 1: PITR restores to a new instance with a new endpoint, never in place
Hint 2: Automated backups are deleted when the instance is deleted, unless you say otherwise
Hint 3: A logical mistake replicates everywhere instantly; only PITR undoes it, not Multi-AZ