A company is planning to deploy an Amazon RDS DB instance running Amazon Aurora. The company has a backup retention policy requirement of 90 days. Which solution should a solutions architect recommend?
A.
Set the backup retention period to 90 days when creating the RDS DB instance.
B.
Configure RDS to copy automated snapshots to a user-managed Amazon S3 bucket with a lifecycle policy set to delete after 90 days.
C.
Create an AWS Backup plan to perform a daily snapshot of the RDS database with the retention set to 90 days. Create an AWS Backup job to schedule the execution of the backup plan daily.
D.
Use a daily scheduled event with Amazon CloudWatch Events to execute a custom AWS Lambda function that makes a copy of the RDS automated snapshot. Purge snapshots older than 90 days.
For me answer is C. how can one store RDS automated snapshots to a user-managed S3 bucket as far as I know RDS store manual and automated snapshots in its own managed S3 bucket which cannot be seen so how we can set a lifecycle policy on that. On the other hand we can control how frequently to take backup and how long to retain that backup in the backup plan.
https://docs.aws.amazon.com/aws-backup/latest/devguide/how-it-works.html
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ExportSnapshot.html
"You can export all types of DB snapshots—including manual snapshots, automated system snapshots, and snapshots created by the AWS Backup service."
I think its B.
C is wrong. It seems you cannot create AWS Backup job. These are only records. Go to your AWS Free Trial -> AWS Backup -> Jobs -> and you will see "Backup Jobs are records of your scheduled or on-demand backups."
Daily schedule of execution is part of Backup plans, NOT Jobs. Go to your AWS Free Trial -> AWS Backup -> Backup Plans -> Create Backup Plan -> Build a new plan -> Backup rule configuration -> Backup frequency -> dropdown -> Daily.
In aws backup service, you create backup plan then assign the resource (aurora DB) to the backup plan.
There is no backup job to create. In this case C will be wrong abd the answer will be B.
There is nothing wrong with option B. It is a valid solution. However, it is important to note that using option B alone may not meet the company's backup retention policy requirement of 90 days, as the lifecycle policy set on the S3 bucket may not be sufficient to retain backups for exactly 90 days. Additionally, it may be more difficult to restore a backup from an S3 bucket than from an RDS snapshot. Therefore, option C may be a better solution as it provides a more reliable way to retain and restore backups with the required retention period.
Option C: Creating an AWS Backup plan to perform a daily snapshot of the RDS database with the retention set to 90 days and scheduling the execution of the backup plan daily is the recommended solution. AWS Backup automates the backup process, which simplifies backup management and ensures backups are retained for the required retention period. Additionally, AWS Backup provides an easy way to restore data from backups, reducing downtime and operational overhead.
Even in AWS webpage (https://aws.amazon.com/getting-started/hands-on/amazon-rds-backup-restore-using-aws-backup/) it says "Configure automatic backup jobs of an amazon RDS database"
feels like a tough question but think i will go with C
B definitely feels viable because they are stating that they are copying to S3 which means the automated backup retention of 35 days shouldn't apply, but they did not state how they are automating the act of copying the snapshot (not 100% sure but think automated backup by RDS is limited to 35 days retention)
on the other hand, AWS probably wants to push their service with these questions so having a service acting as a solution to a use case seems highly likely to me, plus not only they provide the means of automating the backup, retention of 90 days should not really be an issue here
source : https://aws.amazon.com/getting-started/hands-on/amazon-rds-backup-restore-using-aws-backup/
%100 C
why? this text belong to Amazon. if you want more days for backup day, you should create a snapshot.
If you want to retain a backup beyond the backup retention period, you can also take a snapshot of the data in your cluster volume. Because Aurora retains incremental restore data for the entire backup retention period, you only need to create a snapshot for data that you want to retain beyond the backup retention period. You can create a new DB cluster from the snapshot.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Managing.Backups.html
To retain a particular automated snapshot for longer than 35 days, you can copy the snapshot. The copy is stored as a manual snapshot.
but you have to take care on your own of doing this copying of snapshot
C is correct
"The maximum retention period currently available for automated snapshots is 35 days"
So, it is impossible to use the automated snapshot to last 90 days, only manual backup works
https://aws.amazon.com/premiumsupport/knowledge-center/rds-automated-snapshot-retain-longer/#:~:text=The%20maximum%20retention%20period%20currently%20available%20for%20automated%20snapshots%20is%2035%20days.
answer is C;
you cannot configure rds to copy snapshot to s3. it is a manual job to do and not a retention plan. But aws backup provides all neccesities for required retention period.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
QasimNaeem
Highly Voted 3 years, 7 months agokevinhao426
3 years, 3 months agothoughbore
3 years, 5 months agonoahsark
3 years, 6 months agoDS01
3 years, 5 months agoDS01
3 years, 5 months agonoahsark
3 years, 6 months agoanpt
Highly Voted 3 years, 6 months agoguru_ji
3 years, 6 months agopyro_mann
3 years, 6 months agonoahsark
3 years, 6 months agoBECAUSE
Most Recent 1 year, 11 months agoBATSIE
2 years agoAmbrishK
2 years, 1 month agohollie
2 years, 5 months agoSix_Fingered_Jose
2 years, 6 months agokomik_101
2 years, 8 months agoBoss_Sivaji
2 years, 8 months agolbertolini
2 years, 8 months agokrvino18
2 years, 9 months agoIvanaAlawi
2 years, 9 months agoetheng1970
2 years, 10 months agomrsh
2 years, 8 months agomrsh
2 years, 8 months agoBar_t
2 years, 8 months agojosh119891
2 years, 10 months agoVijiTu
2 years, 10 months agoAngrydove
2 years, 10 months agocatborise
3 years ago