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 65 discussion

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

A company is using 5 TB Amazon RDS DB instances and needs to maintain 5 years of monthly database backups for compliance purposes. A Database
Administrator must provide Auditors with data within 24 hours.
Which solution will meet these requirements and is the MOST operationally efficient?

  • A. Create an AWS Lambda function to run on the first day of every month to take a manual RDS snapshot. Move the snapshot to the company's Amazon S3 bucket.
  • B. Create an AWS Lambda function to run on the first day of every month to take a manual RDS snapshot.
  • C. Create an RDS snapshot schedule from the AWS Management Console to take a snapshot every 30 days.
  • D. Create an AWS Lambda function to run on the first day of every month to create an automated RDS snapshot.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by lui at July 25, 2020, 3:19 a.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
Exia
Highly Voted 3 years, 6 months ago
A. Unlike automated backups, manual snapshots aren't subject to the backup retention period. Snapshots don't expire. For very long-term backups of MariaDB, MySQL, and PostgreSQL data, we recommend exporting snapshot data to Amazon S3. If the major version of your DB engine is no longer supported, you can't restore to that version from a snapshot. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CreateSnapshot.html
upvoted 14 times
helpaws
2 years, 8 months ago
So the keyword here is "move to S3". Move means copy to S3 and then delete on RDS. The question asks for "operational efficiency" and "24 hours" to report to auditor. Just leave it in RDS, it doesn't expire and can be easily share right away. B is the answer.
upvoted 3 times
...
...
db2luwdba
Highly Voted 2 years, 9 months ago
There is difference between copy / share a snapshot and Export. Export to S3 option will When you export a DB snapshot, Amazon RDS extracts data from the snapshot and stores it in an Amazon S3 bucket. The data is stored in an Apache Parquet format that is compressed and consistent. Where you have option to copy manual snapshot as is to different region or different AWS account. So we can not basically move the manual snapshot to S3 directly. B is correct.
upvoted 10 times
db2luwdba
2 years, 9 months ago
Plus Unlike automated backups, manual snapshots aren't subject to the backup retention period. Snapshots don't expire. For very long-term backups of MariaDB, MySQL, and PostgreSQL data, we recommend exporting snapshot data to Amazon S3. If the major version of your DB engine is no longer supported, you can't restore to that version from a snapshot. Here the backup movement is only for compliance. there is no requirement to query that backup .( using parquet format query through athena or rds redshift spectrum )
upvoted 3 times
...
...
michalf84
Most Recent 6 months ago
Selected Answer: B
B no need to move snapshots as a suggests
upvoted 1 times
...
michalf84
7 months, 3 weeks ago
Selected Answer: B
No need to move the file it stays in aws
upvoted 1 times
...
rahul2406
1 year ago
B is correct
upvoted 1 times
...
MultiAZ
1 year, 3 months ago
Selected Answer: B
B is the most operationally efficient.
upvoted 1 times
...
jitesh_k
1 year, 4 months ago
https://aws.amazon.com/blogs/database/amazon-rds-snapshot-restore-and-recovery-demystified/#:~:text=Amazon%20RDS%20snapshots%20are%20stored,for%20copy%20and%20restore%20operations. Manual RDS snapshots are stored in S3 anyways. So moving to S3 does not make sense.
upvoted 1 times
...
Sathish_dbs
1 year, 6 months ago
Selected Answer: B
Keep the snapshot the in the RDS itself, no need to waste the operational efficiency by moving to and restoring from S3 unnecessarily
upvoted 1 times
...
milan9527
1 year, 10 months ago
Selected Answer: B
Move to S3 is additional work without efficiency
upvoted 1 times
...
aviathor
1 year, 10 months ago
Selected Answer: A
Actually you do not even need to take a manual snapshot. Even automated snapshots can be exported to S3. You can export all types of DB snapshots—including manual snapshots, automated system snapshots, and snapshots created by the AWS Backup service. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ExportSnapshot.html
upvoted 1 times
...
ninjalight25
2 years, 1 month ago
Selected Answer: C
Option C, creating an RDS snapshot schedule from the AWS Management Console to take a snapshot every 30 days, would be the most operationally efficient solution for this scenario.
upvoted 1 times
Nice_Guy
2 years, 1 month ago
I think the maximum retention period of automated backups is 35 days.
upvoted 2 times
...
...
lollyj
2 years, 4 months ago
Selected Answer: B
This is confusing because don't allow manual snapshots end up in s3 anyway?
upvoted 1 times
...
Maze
2 years, 5 months ago
A. manual snapshot has a limitation. (Each supported Region: 100) this case, customer want to keep backup 5 years.. so i think, it can't possible to keep snapshots during 5 yeers(365*5) https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Limits.html#RDS_Limits.Limits
upvoted 1 times
Maze
2 years, 4 months ago
my mistacke... B is the more correct. because, only need to backups for a month.. so only need to snapshot 12*5 = 60. it does not reach the rds snapshot's limitation.
upvoted 2 times
...
MrAliMohsan
1 year, 11 months ago
Also since they asked for "Operationally Efficient" Option so I also think B is a better answer.
upvoted 1 times
...
leotoras
1 year, 9 months ago
this limit is adjustable, you can really have more than 100 snaps per region
upvoted 1 times
...
...
awsjjj
2 years, 6 months ago
Selected Answer: A
A is the answer. aws recommends long term backups to be exported to s3
upvoted 2 times
...
awsjjj
2 years, 6 months ago
Selected Answer: A
For very long-term backups of MariaDB, MySQL, and PostgreSQL data, we recommend exporting snapshot data to Amazon S3. If the major version of your DB engine is no longer supported, you can't restore to that version from a snapshot. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CreateSnapshot.html
upvoted 2 times
...
yxyj
2 years, 6 months ago
Option B is correct. manual snapshot won't expire.
upvoted 1 times
...
ryuhei
2 years, 10 months ago
Selected Answer: B
I don't think you can move snapshots to individual S3, so the answer is probably B.
upvoted 4 times
...
Load full discussion...
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