Which solution will meet these requirements and is the MOST operationally efficient?

A company is using 5 TB Amazon RDS DB instances and needs to maintain 5 years of monthly database backups for compliance purposes. A Database Administrator must provide Auditors with data within 24 hours.

Which solution will meet these requirements and is the MOST operationally efficient?
A . Create an AWS Lambda function to run on the first day of every month to take a manual RDS snapshot. Move the snapshot to the company’s Amazon S3 bucket.
B . Create an AWS Lambda function to run on the first day of every month to take a manual RDS snapshot.
C . Create an RDS snapshot schedule from the AWS Management Console to take a snapshot every 30 days.
D . Create an AWS Lambda function to run on the first day of every month to create an automated RDS snapshot.

View Answer

Answer: A

Explanation:

Unlike automated backups, manual snapshots aren’t subject to the backup retention period. Snapshots don’t expire. For very long-term backups of MariaDB, MySQL, and PostgreSQL data, we recommend exporting snapshot data to Amazon S3. If the major version of your DB engine is no longer supported, you can’t restore to that version from a snapshot. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CreateSnapshot.html