A company is using an Amazon Aurora MySQL DB cluster that has point-in-time recovery, backtracking, and automatic backup enabled. A SysOps administrator needs to be able to roll back the DB cluster to a specific recovery point within the previous 72 hours. Restores must be completed in the same production DB cluster.
Which solution will meet these requirements?
- Create an Aurora Replica. Promote the replica to replace the primary DB instance.
- Create an AWS Lambda function to restore an automatic backup to the existing DB cluster.
- Use backtracking to rewind the existing DB cluster to the desired recovery point.
- Use point-in-time recovery to restore the existing DB cluster to the desired recovery point.
Answer(s): C
Reference:
https://aws.amazon.com/premiumsupport/knowledge-center/aurora-mysql-slow-snapshot-restore/

Reveal Solution Next Question