Exam AWS Certified Database - Specialty topic 1 question 39 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 39
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A Database Specialist is planning to create a read replica of an existing Amazon RDS for MySQL Multi-AZ DB instance. When using the AWS Management
Console to conduct this task, the Database Specialist discovers that the source RDS DB instance does not appear in the read replica source selection box, so the read replica cannot be created.
What is the most likely reason for this?

A. The source DB instance has to be converted to Single-AZ first to create a read replica from it.
B. Enhanced Monitoring is not enabled on the source DB instance.
C. The minor MySQL version in the source DB instance does not support read replicas.
D. Automated backups are not enabled on the source DB instance.

Show Suggested Answer

Suggested Answer: D 🗳️

by avland at Nov. 11, 2021, 9:31 p.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

RotterDam

Highly Voted 3 years, 3 months ago

Selected Answer: D

(D) is correct In order to create a read replica - Automated Backups MUST be enabled Additionally for SQL Server - Source MUST be Multi-AZ deployment with Always On Availability Groups (AG)

upvoted 6 times

...

novice_expert

Highly Voted 3 years, 1 month ago

Selected Answer: D

D. Automated backups are not enabled on the source DB instance. In order to create a read replica - Automated Backups MUST be enabled Additionally for SQL Server - Source MUST be Multi-AZ deployment with Always On Availability Groups (AG)

upvoted 5 times

...

Pranava_GCP

Most Recent 1 year, 9 months ago

Selected Answer: D

D. Automated backups are not enabled on the source DB instance. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_MultiAZDBCluster_ReadRepl.html "You must turn on automatic backups on the source DB instance by setting the backup retention period to a value other than 0."

upvoted 1 times

...

awsmonster

3 years, 4 months ago

Ans: D

upvoted 2 times

...

avland

3 years, 6 months ago

D. >Your source DB instance must have backup retention enabled. https://docs.aws.amazon.com/AmazonRDS/latest/APIReference/API_CreateDBInstanceReadReplica.html

upvoted 2 times

...