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

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

Submit Cancel

Exia

Highly Voted 3 years, 8 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, 10 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, 11 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, 11 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 8 months ago

Selected Answer: B

B no need to move snapshots as a suggests

upvoted 1 times

...

michalf84

9 months, 2 weeks ago

Selected Answer: B

No need to move the file it stays in aws

upvoted 1 times

...

rahul2406

1 year, 1 month ago

B is correct

upvoted 1 times

...

MultiAZ

1 year, 5 months ago

Selected Answer: B

B is the most operationally efficient.

upvoted 1 times

...

jitesh_k

1 year, 6 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, 8 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

2 years ago

Selected Answer: B

Move to S3 is additional work without efficiency

upvoted 1 times

...

aviathor

2 years 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, 3 months 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, 3 months ago

I think the maximum retention period of automated backups is 35 days.

upvoted 2 times

...

lollyj

2 years, 6 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, 6 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, 6 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

2 years ago

Also since they asked for "Operationally Efficient" Option so I also think B is a better answer.

upvoted 1 times

...

leotoras

1 year, 11 months ago

this limit is adjustable, you can really have more than 100 snaps per region

upvoted 1 times

...

awsjjj

2 years, 8 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, 8 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, 8 months ago

Option B is correct. manual snapshot won't expire.

upvoted 1 times

...

ryuhei

2 years, 11 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...