ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 150 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 150
Topic #: 1
[All AWS Certified Database - Specialty Questions]

A finance company needs to make sure that its MySQL database backups are available for the most recent 90 days. All of the MySQL databases are hosted on
Amazon RDS for MySQL DB instances. A database specialist must implement a solution that meets the backup retention requirement with the least possible development effort.
Which approach should the database specialist take?

  • A. Use AWS Backup to build a backup plan for the required retention period. Assign the DB instances to the backup plan.
  • B. Modify the DB instances to enable the automated backup option. Select the required backup retention period.
  • C. Automate a daily cron job on an Amazon EC2 instance to create MySQL dumps, transfer to Amazon S3, and implement an S3 Lifecycle policy to meet the retention requirement.
  • D. Use AWS Lambda to schedule a daily manual snapshot of the DB instances. Delete snapshots that exceed the retention requirement.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by hemantr at Nov. 13, 2021, 1:14 p.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Shunpin
Highly Voted 3 years, 4 months ago
Ans: A Auto Backup is 35 Max. Creating Backup plan and Create on-demand backup are the solution.
upvoted 5 times
...
KikiNoviandi
Most Recent 1 year, 6 months ago
Selected Answer: D
not A because, AWS backup has a 35 day retention policy
upvoted 2 times
Hisayuki
1 year, 3 months ago
No. The answer is A. Auto backup is actually 35 days as maximum. You should manually backup for 90 days. Then you can two choices to control the manual backup (or snapshot) which you can define longer retention period than 35 days of RDS automated backup. - use AWS Backup so that you make a schedule to create a manual snapshot - use the Lambda Function to make a schedule to create a manual snapshot Of course, AWS Backup is easier than implements of Lambda.
upvoted 1 times
...
...
Pranava_GCP
1 year, 7 months ago
Selected Answer: A
A. Use AWS Backup to build a backup plan for the required retention period. Assign the DB instances to the backup plan.
upvoted 2 times
...
CallMeHerb
1 year, 8 months ago
Can't believe so many votes for A. AWS backup also has a 35 day retention policy and the same page references snapshots. A is 100% incorrect https://docs.aws.amazon.com/aws-backup/latest/devguide/point-in-time-recovery.html
upvoted 1 times
Pranava_GCP
1 year, 7 months ago
AWS Backup can retain snapshots between 1 day and 100 years (or indefinitely, if you do not enter a retention period), and continuous backups between 1 and 35 days.
upvoted 3 times
...
...
MrAliMohsan
1 year, 11 months ago
Selected Answer: A
Not Selecting D Since it is more development effort.
upvoted 2 times
...
yyy
2 years ago
Ans: D
upvoted 2 times
...
Chirantan
2 years, 9 months ago
max limit for automated backups is 35 days hene manual snapshot is solution https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.html#USER_WorkingWithAutomatedBackups.BackupRetention
upvoted 2 times
...
Chirantan
2 years, 9 months ago
You can set the backup retention period when you create a DB instance. If you don't set the backup retention period, the default backup retention period is one day if you create the DB instance using the Amazon RDS API or the AWS CLI. The default backup retention period is seven days if you create the DB instance using the console. After you create a DB instance, you can modify the backup retention period. You can set the backup retention period to between 0 and 35 days. Setting the backup retention period to 0 disables automated backups. Manual snapshot limits (100 per Region) do not apply to automated backups. max limit for automated backups is 35 days hen e manual snapshot is solution https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.html#USER_WorkingWithAutomatedBackups.BackupRetention
upvoted 1 times
...
megadba
2 years, 10 months ago
RDS autobackup's retention period is max 35days
upvoted 2 times
...
novice_expert
3 years ago
Selected Answer: A
AWS Backup service + retention period set
upvoted 4 times
...
tugboat
3 years, 2 months ago
Selected Answer: A
Agree with other comments
upvoted 2 times
...
mnzsql365
3 years, 4 months ago
A for me - AWS Backup Service solution
upvoted 1 times
...
nood
3 years, 4 months ago
A for me https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.html B is wrong , because Automated backups with unsupported MySQL storage engines .
upvoted 1 times
...
Justu
3 years, 5 months ago
Automatic backups are only for max 35 days
upvoted 2 times
...
hemantr
3 years, 5 months ago
A https://aws.amazon.com/getting-started/hands-on/amazon-rds-backup-restore-using-aws-backup/
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago