AWS Certified Database – Specialty — Question 52

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?

Answer options

• 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.

Correct answer: B

Explanation

Option B is correct because it provides a straightforward method to manually create RDS snapshots monthly without additional complexity. Option A adds unnecessary steps by moving snapshots to S3, while C only schedules snapshots every 30 days, which does not meet the requirement for monthly backups. Option D suggests automation, but the question specifies a manual snapshot process.