AWS Certified SysOps Administrator – Associate — Question 11

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?

Answer options

• A. Create an Aurora Replica. Promote the replica to replace the primary DB instance.
• B. Create an AWS Lambda function to restore an automatic backup to the existing DB cluster.
• C. Use backtracking to rewind the existing DB cluster to the desired recovery point.
• D. Use point-in-time recovery to restore the existing DB cluster to the desired recovery point.

Correct answer: C

Explanation

The correct answer is C because backtracking allows the DB cluster to be rewound to a specific point in time within the last 72 hours without needing to restore from backups or create replicas. Options A and B do not provide a direct method to roll back to a specific recovery point, while option D, although it involves restoration, does not allow for the same production cluster to be used directly in the process.