Exam AWS Certified Database - Specialty topic 1 question 304 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 304
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company has a Microsoft SQL Server 2017 Enterprise edition on Amazon RDS database with the Multi-AZ option turned on. Automatic backups are turned on and the retention period is set to 7 days. The company needs to add a read replica to the RDS DB instance.

How should a database specialist achieve this task?

A. Turn off the Multi-AZ feature, add the read replica, and turn Multi-AZ back on again.
B. Set the backup retention period to 0, add the read replica, and set the backup retention period to 7 days again.
C. Restore a snapshot to a new RDS DB instance and add the DB instance as a replica to the original database.
D. Add the new read replica without making any other changes to the RDS database.

Show Suggested Answer

Suggested Answer: D 🗳️

by rdiaz at March 26, 2023, 5:20 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

MultiAZ

1 year, 6 months ago

Selected Answer: D

D No need to disable multi-az before creating a replica

upvoted 1 times

...

Windy

1 year, 11 months ago

It's D.

upvoted 2 times

...

tsk9921

2 years, 2 months ago

D is right

upvoted 1 times

...

rdiaz

2 years, 3 months ago

Selected Answer: D

https://aws.amazon.com/blogs/database/using-in-region-read-replicas-in-amazon-rds-for-sql-server/

upvoted 3 times

Mintwater

2 years, 3 months ago

Thank you rdiaz, this is an exact link: When you create a read replica, Amazon RDS takes a snapshot of the primary DB instance and creates a new read-only instance from the snapshot. Creating or deleting the read replica doesn’t require any downtime on the primary DB instance. You can create up to fifteen read replicas. Note: the same region, EE

upvoted 1 times

...