DBS-C01 Question #22: Real Exam Question with Answer & Explanation

Question

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?

Options

• ACreate an AWS Lambda function to run on the first day of every month to take a manual RDS
• BCreate an AWS Lambda function to run on the first day of every month to take a manual RDS
• CCreate an RDS snapshot schedule from the AWS Management Console to take a snapshot every
• DCreate an AWS Lambda function to run on the first day of every month to create an automated

Explanation

Explanation

Option A is correct because it involves creating a Lambda function to take manual RDS snapshots on the first day of each month and copy them to Amazon S3, where a lifecycle policy can retain them for exactly 5 years - this approach is fully automated, cost-effective, durable, and allows auditors to retrieve data within 24 hours. Options B and D are distractors that likely describe incomplete or incorrect implementations, such as storing snapshots in the wrong location or using automated snapshots (which are limited to a maximum retention period of 35 days, making 5-year retention impossible). Option C, using the RDS snapshot schedule from the Management Console, is less operationally efficient and may not support copying snapshots to S3 with a lifecycle policy for long-term retention management.

Memory Tip 🧠

Remember: "Automated RDS snapshots max out at 35 days" - any compliance requirement beyond that means you need manual snapshots stored in S3 with lifecycle policies. Think "Long-term = Lambda + S3."

No community discussion yet for this question.