nerdexam
Amazon

SOA-C02 · Question #377

A company plans to deploy a database on an Amazon Aurora MySQL DB cluster. The database will store data for a demonstration environment. The data must be reset on a daily basis. What is the MOST…

The correct answer is B. Enable the Backtrack feature during the creation of the DB cluster. Specify a target backtrack. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.Ba

Submitted by yasin.bd· Mar 30, 2026Reliability and Business Continuity

Question

A company plans to deploy a database on an Amazon Aurora MySQL DB cluster. The database will store data for a demonstration environment. The data must be reset on a daily basis. What is the MOST operationally efficient solution that meets these requirements?

Options

  • ACreate a manual snapshot of the DB cluster after the data has been populated. Create an
  • BEnable the Backtrack feature during the creation of the DB cluster. Specify a target backtrack
  • CExport a manual snapshot of the DB cluster to an Amazon S3 bucket after the data has been
  • DSet the DB cluster backup retention period to 2 days. Create an Amazon EventBridge (Amazon

How the community answered

(59 responses)
  • A
    5% (3)
  • B
    83% (49)
  • C
    10% (6)
  • D
    2% (1)

Explanation

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.Ba

Topics

#Aurora Backtrack#database reset#point-in-time restore#operational efficiency

Community Discussion

No community discussion yet for this question.

Full SOA-C02 Practice