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…

The correct answer is C. Use backtracking to rewind the existing DB cluster to the desired recovery point. https://aws.amazon.com/premiumsupport/knowledge-center/aurora-mysql-slow-snapshot-restore/ https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.Ba

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.

How the community answered

(26 responses)
  • A
    15% (4)
  • B
    8% (2)
  • C
    73% (19)
  • D
    4% (1)

Explanation

https://aws.amazon.com/premiumsupport/knowledge-center/aurora-mysql-slow-snapshot-restore/ https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.Ba

Topics

#Aurora backtracking#point-in-time recovery#DB cluster rollback#Aurora MySQL

Community Discussion

No community discussion yet for this question.

Full SOA-C02 Practice