nerdexam
Amazon

SOA-C02 · Question #720

A company runs databases on Amazon RDS for MySQL DB instances. The company must generate database backups every 12 hours for all the DB instances. The company must retain the backups for 5 years. A…

The correct answer is D. Use AWS Backup to create an automated backup job in Amazon RDS. Set the backup frequency. AWS Backup natively supports RDS, lets you schedule backups every 12 hours, and set retention to years (5 years here). RDS automated backups can’t retain that long, so AWS Backup is the lowest-overhead way to meet both frequency and long-term retention.

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

Question

A company runs databases on Amazon RDS for MySQL DB instances. The company must generate database backups every 12 hours for all the DB instances. The company must retain the backups for 5 years. A SysOps administrator needs to develop an automated solution to generate and retain the database backups. Which solution will meet these requirements with the LEAST operational overhead?

Options

  • AEnable RDS automated backups. Set the backup frequency to 12 hours. Set the retention period
  • BConfigure an Amazon EventBridge rule to call the RDS CreateDBSnapshot API operation. Set the
  • CConfigure an AWS Lambda function to call the RDS CreateDBSnapshot API operation every 12
  • DUse AWS Backup to create an automated backup job in Amazon RDS. Set the backup frequency

How the community answered

(15 responses)
  • B
    7% (1)
  • C
    13% (2)
  • D
    80% (12)

Explanation

AWS Backup natively supports RDS, lets you schedule backups every 12 hours, and set retention to years (5 years here). RDS automated backups can’t retain that long, so AWS Backup is the lowest-overhead way to meet both frequency and long-term retention.

Topics

#AWS Backup#RDS automated backups#backup retention policy#least operational overhead

Community Discussion

No community discussion yet for this question.

Full SOA-C02 Practice