An operator accidentally deleted rows in an Aurora MySQL cluster two hours ago. The team must return the cluster to a point before the mistake without restoring a snapshot or creating a new cluster. Which feature applies?
Show answer and explanation
Answer: A
Aurora Backtrack rewinds an Aurora MySQL cluster in place to an earlier point in time within the backtrack window, which can be configured up to 72 hours. It is designed for exactly this case: a recent logical error where a full snapshot restore would be slow and disruptive.
The cluster keeps its endpoint, so applications reconnect without being repointed.
Why the other options are wrong
- B. Multi-AZ failover replaces a failed instance or Availability Zone but does not undo committed writes.
- C. Promoting a replica creates a new writer from replicated data and cannot remove deletions already applied.
- D. Restore testing validates that backups can be restored; it does not modify the live cluster.