A company regulatory compliance policy requires that all RDS backups occur automatically on a specified schedule and are stored for 90 days. What is the optimal solution to meet this requirement?

Answer options:

A.Enable automated backups on RDS.Configure backup retention period to 90 days.
B.Implement a Lambda function to create an RDS DB snapshot. Create CloudWatch Events Rule to trigger the Lambda function according to the required schedule.
C.Implement a Step Function to copy the RDS backup to an S3 bucket.Configure Start condition of the Step Function to execute according to the required schedule.
D.Configure RDS backup lifecycle policy to archive data in S3 Glacier.

Answer: B
Option A is incorrect because the automated RDS backup retention period has a maximum configurable value of 35 days.
Option B is CORRECT because to retain backups longer than 35 days, RDS snapshots must be used. Lambda function can be implemented to initiate the RDS snapshot. The Lambda function can be triggered on a schedule using CloudWatch Events Rule.
Option C is incorrect because RDS does not offer the capability to copy automated backups.
Option D is incorrect because RDS backup does not have lifecycle policy functionality
Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.html
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CreateSnapshot.html