AWS Certified SysOps Administrator – Associate (SOA-C03) — Question 7

A company is using an Amazon Aurora MySQL DB cluster that has point-in-time recovery, backtracking, and automatic backup enabled. A CloudOps engineer 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 duster 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 without needing to create a new instance or disrupt service. Option A is incorrect as promoting a replica does not restore to a specific point; option B does not utilize the existing cluster for restoration; and option D involves point-in-time recovery which is not as efficient as backtracking for this requirement.