Exam AWS Certified Database - Specialty topic 1 question 220 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 220
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A development team asks a database specialist to create a copy of a production Amazon RDS for MySQL DB instance every morning. The development team will use the copied DB instance as a testing environment for development. The original DB instance and the copy will be hosted in different VPCs of the same AWS account. The development team wants the copy to be available by 6 AM each day and wants to use the same endpoint address each day.
Which combination of steps should the database specialist take to meet these requirements MOST cost-effectively? (Choose three.)

A. Create a snapshot of the production database each day before the 6 AM deadline.
B. Create an RDS for MySQL DB instance from the snapshot. Select the desired DB instance size.
C. Update a defined Amazon Route 53 CNAME record to point to the copied DB instance.
D. Set up an AWS Database Migration Service (AWS DMS) migration task to copy the snapshot to the copied DB instance.
E. Use the CopySnapshot action on the production DB instance to create a snapshot before 6 AM.
F. Update a defined Amazon Route 53 alias record to point to the copied DB instance.

Show Suggested Answer

Suggested Answer: ABC 🗳️

by mbar94 at Sept. 5, 2022, 8:49 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

cloudsunriser

Highly Voted 2 years, 9 months ago

Selected Answer: ABC

ABC is correct. E is I guess for copying EBS volume snapshots and not for RDS. DMS is not required and it's not alias record.

upvoted 5 times

...

MultiAZ

Most Recent 1 year, 5 months ago

Selected Answer: ABF

ABF See https://aaron-janes.medium.com/are-you-using-route53-with-cname-or-alias-records-to-route-dns-requests-in-your-organization-56166ded5cd4

upvoted 1 times

...

Pranava_GCP

1 year, 10 months ago

Selected Answer: ABC

ABC is correct

upvoted 2 times

...

teo2157

2 years, 4 months ago

Selected Answer: ABC

CNAME records can route traffic to Elastic Beanstalk environments and RDSs, Alias records routes traffic to EC2, ELB, S3 and so on

upvoted 3 times

...

lollyj

2 years, 6 months ago

Selected Answer: ABF

Can someone explain why a CNAME record isn't chosen over ALIAS record? From my understanding Alias records do not support RDS DNS endpoints. Any thoughts?

upvoted 1 times

...