Q87 — AWS SAA-C03 Ch.12

Question 87 of 100 | ← Chapter 12

Q887. A company uses Amazon RDS with default backup settings for its database tier. The company needs to make a daily backup of the database to meet regulatory requirements. The company must retain the backups for 30 days.Which solution will meet these requirements with the LEAST operational overhead?

Correct Answer: B. Modify the RDS database to have a retention period of 30 days for automated backups.

Explanation

To meet the requirement of making a daily backup of the database and retaining the backups for 30 days with the least operational overhead, the following solution can be implemented:B. Modify the RDS database to have a retention period of 30 days for automated backups.Amazon RDS provides automated backups for databases, which are enabled by default. By modifying the RDS database to have a retention period of 30 days for automated backups, the company can ensure that a daily backup of the database is performed and the backups are retained for the required duration without any additional operational overhead. This is the simplest and most efficient solution as it leverages the built-in backup functionality provided by Amazon RDS.Option A suggests writing an AWS Lambda function to create an RDS snapshot every day. While this approach can achieve the desired daily backup, it introduces additional complexity by requiring the development and management of a custom Lambda function. This results in increased operational overhead compared to using the built-in automated backup feature of Amazon RDS.Option C suggests using AWS Systems Manager Maintenance Windows to modify the RDS backup retention period. While Maintenance Windows can be used to schedule tasks and automate management operations, modifying the RDS backup retention period through this method adds unnecessary complexity. The desired retention period can be directly set in the RDS configuration settings, eliminating the need for Maintenance Windows in this scenario.Option D suggests creating a manual snapshot every day using the AWS CLI and modifying the RDS backup retention period. While this approach can achieve the daily backup requirement, it requires manual intervention and management of the snapshot creation process. This introduces additional operational overhead compared to using the automated backup feature of Amazon RDS.In summary, to meet the requirement of making a daily backup of the database and retaining the backups for 30 days with the least operational overhead, modifying the RDS database to have a retention period of 30 days for automated backups (Option B) is the most efficient solution.