A developer is doing some testing on an application using the Amazon Aurora database. During the testing activities, the developer accidentally executes a DELETE statement without a WHERE clause. They wish to undo this action. What is the optimal solution to revert the database to the correct state with minimal effort?

Answer options:

A.Use Amazon Aurora Backtracking feature.
B.Use Amazon Aurora “Restore to point in time” feature.
C.Restore the Amazon Aurora database from a snapshot.
D.Restore the Amazon Aurora from a read replica.

Answer: A
Option A is CORRECT because Amazon Aurora backtracking ability enables one to revert an Amazon Aurora cluster to a specific point in time without restoring data from a backup.
Option B incorrect because restoring an Amazon Aurora cluster using the point in time feature launches a new cluster and restores it from backup data. Restoring from backup is a very time-consuming process that can take hours to complete. Further, this solution has costs associated with the additional Amazon Aurora cluster.
Option C is incorrect because restoring from a snapshot does not restore data to a specific desired point in time. Additionally, restoring from a snapshot launches a new cluster, thus incurring additional costs. Since the restore happens from backup data, it can take hours to complete. Therefore, this is not the optimal solution.
Option D is incorrect because it is not possible to perform a restore from a read replica.
Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.Backtrack.html