Amazon Exam DBS-C01 Topic 7 Question 63 Discussion

Actual exam question for Amazon's DBS-C01 exam

Question #: 63
Topic #: 7

Recently, an ecommerce business transferred one of its SQL Server databases to an Amazon RDS for SQL Server Enterprise Edition database instance. The corporation anticipates an increase in read traffic as a result of an approaching sale. To accommodate the projected read load, a database professional must establish a read replica of the database instance.

Which procedures should the database professional do prior to establishing the read replica? (Select two.)

AIdentify a potential downtime window and stop the application calls to the source DB instance.

BEnsure that automatic backups are enabled for the source DB instance.

CEnsure that the source DB instance is a Multi-AZ deployment with Always ON Availability Groups.

DEnsure that the source DB instance is a Multi-AZ deployment with SQL Server Database Mirroring (DBM).

EModify the read replica parameter group setting and set the value to 1.

Show Suggested Answer

Suggested Answer: B, C

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

by Zona at Sep 22, 2022, 04:57 PM

Limited Time Offer

25%

Off

Get Premium DBS-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!