Exam AWS Certified Database - Specialty topic 1 question 265 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 265
Topic #: 1

[All AWS Certified Database - Specialty Questions]

An ecommerce company runs an application on Amazon RDS for SQL Server 2017 Enterprise edition. Due to the increase in read volume, the company’s application team is planning to offload the read transactions by adding a read replica to the RDS for SQL Server DB instance.

What architectural conditions should a database specialist set? (Choose two.)

A. Ensure that the automatic backups are turned on for the RDS DB instance
B. Ensure the backup retention value is set to 0 for the RDSDB instance
C. Ensure the RDS DB instance is set to Multi-AZ
D. Ensure the RDS DB instance is set to Single-AZ
E. Ensure the RDS DB instance is in a stopped state to turn on the read replica

Show Suggested Answer

Suggested Answer: AC 🗳️

by Sab at Nov. 30, 2022, 11:18 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

Sab

Highly Voted 2 years, 6 months ago

AC https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.ReadReplicas.html

upvoted 5 times

...

Pranava_GCP

Most Recent 1 year, 9 months ago

Selected Answer: AC

A. Ensure that the automatic backups are turned on for the RDS DB instance C. Ensure the RDS DB instance is set to Multi-AZ https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.ReadReplicas.html

upvoted 1 times

...

milofficial

2 years, 3 months ago

Selected Answer: AC

AC it is

upvoted 1 times

...

Don2021

2 years, 5 months ago

AC you must enable automatic backups on the source DB instance. To do so, you set the backup retention period to a value other than 0. The source DB instance must be a Multi-AZ deployment with Always On Availability Groups (AGs). Setting this type of deployment also enforces that automatic backups are enabled.

upvoted 2 times

...