Exam AWS Certified Database - Specialty topic 1 question 312 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 312
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company runs an Amazon Aurora MySQL DB instance for one of its critical applications. The company’s marketing department sends promotional email messages to customers based on the data in this database. A database engineer needs to make the data from all the tables available in the company’s Amazon S3 data lake. The database engineer wants to perform an export from a snapshot to populate the S3 data lake with the contents of the database.

Which combination of steps will meet these requirements with the LEAST operational overhead? (Choose three.)

A. Use an existing automated snapshot or manual snapshot, or create a manual snapshot of the DB instance.
B. Identify the S3 bucket for export. Provide access to the S3 bucket by using an IAM user. Attach an IAM policy with s3:PutObject*, s3:GetObject*, s3:ListBucket, s3:DeleteObject*, and s3:GetBucketLocation permissions to the IAM user. Attach the IAM role to the DB instance.
C. Create a copy of an existing automated snapshot or manual snapshot of the DB instance.
D. Create a symmetric AWS Key Management Service (AWS KMS) key for server-side encryption. Export the snapshot to Amazon S3.
E. Identify the S3 bucket for export. Provide access to the S3 bucket by using an IAM role. Attach an IAM policy with s3:PutObject*, s3:GetQpject*, s3:ListBucket, s3:DeleteObject*, and s3:GetBucketLocation permissions to the IAM role. Attach the IAM role to the DB instance.
F. Create a symmetric AWS Key Management Service (AWS KMS) key for server-side encryption. Export the snapshot to Amazon S3 Glacier Flexible Retrieval.

Show Suggested Answer

Suggested Answer: ADE 🗳️

by TQM__9MD at July 14, 2023, 12:59 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

rn30

Highly Voted 1 year, 11 months ago

ADE Refer https://www.youtube.com/watch?v=lyNGeDg6EII

upvoted 6 times

...

Pranava_GCP

Highly Voted 1 year, 10 months ago

Selected Answer: ADE

A,D,E is the correct answer. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ExportSnapshot.html

upvoted 5 times

...

MultiAZ

Most Recent 1 year, 6 months ago

Selected Answer: ADE

ADE We need IAM role, not IAM user We need the least overhead

upvoted 2 times

...

DanShone

1 year, 10 months ago

Selected Answer: ADE

B: IAM User, this must be a Role so D C: Option A is better F: Question doesn't mention archiving the data anywhere

upvoted 3 times

...

zanhsieh

1 year, 10 months ago

Selected Answer: ADE

ADE. B: No. Shall provide IAM role, not the IAM user. C: No. Opt A has better scope. F: No. This operation would be cost saving but NOT LEAST operation overhead.

upvoted 3 times

...

Monknil

1 year, 11 months ago

A,D,E is the correct answer.

upvoted 3 times

...

TQM__9MD

1 year, 12 months ago

Selected Answer: ABC

A,B,C is answer A. Create an existing automatic snapshot or a manual snapshot of the DB instance. This saves the content of the database as a snapshot. B. Identify the S3 bucket to export to and provide access to the bucket using an IAM user. Attach an IAM policy to the IAM user with permissions such as s3:PutObject*, s3:GetObject*, s3:ListBucket, s3:DeleteObject*, and s3:GetBucketLocation. Attach an IAM role to the DB instance. This allows the DB instance to have access to the S3 bucket. C. Create a copy of the existing automatic snapshot or manual snapshot of the DB instance. This creates a copy of the snapshot. Therefore, the combination of steps that meets these requirements with minimal operational overhead is A, B, and C.

upvoted 2 times

...