SOA-C03 Question #8: Real Exam Question with Answer & Explanation

Question

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 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?

Options

• ACreate an Aurora Replica. Promote the replica to replace the primary DB instance.
• BCreate an AWS Lambda function to restore an automatic backup to the existing DB cluster.
• CUse backtracking to rewind the existing DB cluster to the desired recovery point.
• DUse point-in-time recovery to restore the existing DB cluster to the desired recovery point.

Explanation

Explanation

Backtracking (Option C) is the correct solution because it uniquely allows you to rewind an existing Aurora DB cluster to a previous state in place, without creating a new cluster - making it the only option that satisfies the "same production DB cluster" requirement. Aurora backtracking supports windows up to 72 hours, which aligns perfectly with the stated requirement.

Option A is wrong because promoting an Aurora Replica creates a new primary instance rather than restoring the existing cluster to a specific point in time. Option B is wrong because automatic backup restores always create a new DB cluster - you cannot restore a backup directly into an existing cluster, and Lambda doesn't change this behavior. Option D is wrong because point-in-time recovery (PITR), despite its name, also spins up a new DB cluster rather than modifying the existing one in place.

🧠 Memory Tip: Think of Backtracking = "Rewind" - just like rewinding a tape on the same player. PITR and automatic backups are like making a copy of the tape on a new player. Whenever the exam says "same cluster," think Backtracking.

No community discussion yet for this question.