exam questions

Exam AWS Certified Database - Specialty All Questions

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

Exam AWS Certified Database - Specialty topic 1 question 41 discussion

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

A company has an Amazon RDS Multi-AZ DB instances that is 200 GB in size with an RPO of 6 hours. To meet the company's disaster recovery policies, the database backup needs to be copied into another Region. The company requires the solution to be cost-effective and operationally efficient.
What should a Database Specialist do to copy the database backup into a different Region?

  • A. Use Amazon RDS automated snapshots and use AWS Lambda to copy the snapshot into another Region
  • B. Use Amazon RDS automated snapshots every 6 hours and use Amazon S3 cross-Region replication to copy the snapshot into another Region
  • C. Create an AWS Lambda function to take an Amazon RDS snapshot every 6 hours and use a second Lambda function to copy the snapshot into another Region
  • D. Create a cross-Region read replica for Amazon RDS in another Region and take an automated snapshot of the read replica
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

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
Ebi
Highly Voted 3 years, 8 months ago
Answer is C A. Use Amazon RDS automated snapshots and use AWS Lambda to copy the snapshot into another Region Automated snapshots are taken once per day only, RPO is 6 hours, so not an option B. Use Amazon RDS automated snapshots every 6 hours and use Amazon S3 cross-Region replication to copy the snapshot into another Region You can not take automated snapshots every 6 hours C. Create an AWS Lambda function to take an Amazon RDS snapshot every 6 hours and use a second Lambda function to copy the snapshot into another Region Only possible option D. Create a cross-Region read replica for Amazon RDS in another Region and take an automated snapshot of the read replica Not cost-effective, replica is the most expensive DR option.
upvoted 27 times
szmulder
3 years, 8 months ago
It's hard to choose. A is correct is RDS can restore to point in time, so we don't need to do a snapshot every 6 hours.
upvoted 1 times
...
zanhsieh
3 years, 8 months ago
Agreed with C. Any options mention / use 'automated snapshot' should be dropped, so no ABD. Verified via AWS console in RDS. Change time interval for RDS automatic backup period to 0 means disable automatic backup. See: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.html
upvoted 3 times
...
...
MultiAZ
Most Recent 1 year, 4 months ago
Selected Answer: C
Anser is C. D is not the most cost-effective A and B are not OK because automated snapshots are only once a day and you need one every 6 hours
upvoted 1 times
...
SuriSagar
1 year, 8 months ago
C is the correct answer
upvoted 2 times
...
aviathor
2 years ago
It would be so much easier to use cross-region backup replication... https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReplicateBackups.html
upvoted 1 times
...
sachin
2 years, 11 months ago
Copying 200 Gb of snapshot every 6 hours across region will be costlier approach and ensuring lambda to finish job of coping 200gb snapshot with 15 mins is also not viable. So i think D is best choice.
upvoted 3 times
...
awsguys
3 years ago
c is right .
upvoted 1 times
...
novice_expert
3 years, 1 month ago
Selected Answer: C
x A & B out: only automated snapshot per day allowed we need 4 C. Create an AWS Lambda function to take an Amazon RDS snapshot every 6 hours and use a second Lambda function to copy the snapshot into another Region (cost effective) D. Create a cross-Region read replica for Amazon RDS in another Region and take an automated snapshot of the read replica (costly)
upvoted 1 times
...
RotterDam
3 years, 3 months ago
Selected Answer: C
Definitely (C) - also a question in the pfficial sample exam discussed by Stephen Maarek and Riyaz in their Udemy course
upvoted 1 times
...
Shunpin
3 years, 5 months ago
Selected Answer: C
System snapshot can't fulfill 6 hours requirement. You need to control it by script https://aws.amazon.com/blogs/database/%C2%AD%C2%AD%C2%ADautomating-cross-region-cross-account-snapshot-copies-with-the-snapshot-tool-for-amazon-aurora/
upvoted 1 times
...
guru_ji
3 years, 7 months ago
Anyone planning for exam? We can share study material with each other, it would be beneficial for both. You can email me on "awsdbguru at gmail"
upvoted 1 times
...
guru_ji
3 years, 7 months ago
Correct Answer is ==>> C. any idea how much Q we will get in real exam from Q available here? anyone is preparing for this exam and want to do group study with us, comment with mail id.
upvoted 1 times
...
ChauPhan
3 years, 7 months ago
https://aws.amazon.com/blogs/database/implementing-a-disaster-recovery-strategy-with-amazon-rds/ Automated Backup is daily, so 6 hour RPO is not possible. Only C is correct.
upvoted 1 times
...
Dip11
3 years, 7 months ago
Answer is C. Reason for eliminating D is that RDS SQL SERVER does not support cross-region read replica and the question does not state which database engine used in RDS.
upvoted 1 times
...
LMax
3 years, 7 months ago
Agree with C
upvoted 2 times
...
Windy
3 years, 7 months ago
I think it is C.
upvoted 1 times
...
myutran
3 years, 7 months ago
Ans: D with key "operationally efficient". With option C, it is necessary to copy 200GB of data from one region to another every 6 hours.
upvoted 2 times
Germaneli
1 year, 8 months ago
With C, it would be required for a Lambda function to copy 200 GB in 15 mins (max execution time) - every 6 hours. It might be feasible given a decent throughput (cross-region!), but that's not guaranteed and there's no mention of the available throughput.
upvoted 1 times
...
...
JobinAkaJoe
3 years, 7 months ago
A - wrong - I guess you cannot copy automated snapshots to another region. You must create a copy of automated snapshot in the same region first. B - wrong - automated snapshots are taken once in a day which alone wouldnt meet proposed RPO of 6hrs C - best answer for the requirement in hand. D - best option for cross region DR. However having a read-replica in another region is costlier than option C
upvoted 1 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
Loading ...