nerdexam
Amazon

SOA-C02 · Question #39

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

Sign in or unlock SOA-C02 to reveal the answer and full explanation for question #39. The question stem and answer options stay visible for context.

Submitted by carter_n· Mar 30, 2026Reliability and Business Continuity

Question

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?

Exhibit

SOA-C02 question #39 exhibit

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.

Unlock SOA-C02 to see the answer

You've previewed enough free SOA-C02 questions. Unlock SOA-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Aurora backtracking#point-in-time recovery#DB cluster rollback#Aurora MySQL
Full SOA-C02 Practice