DBS-C01 · Question #165
An ecommerce company recently migrated one of its SQL Server databases to an Amazon RDS for SQL Server Enterprise Edition DB instance. The company expects a spike in read traffic due to an upcoming sa
Sign in or unlock DBS-C01 to reveal the answer and full explanation for question #165. The question stem and answer options stay visible for context.
Question
An ecommerce company recently migrated one of its SQL Server databases to an Amazon RDS for SQL Server Enterprise Edition DB instance. The company expects a spike in read traffic due to an upcoming sale. A database specialist must create a read replica of the DB instance to serve the anticipated read traffic. Which actions should the database specialist take before creating the read replica? (Choose two.)
Options
- 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
- EModify the read replica parameter group setting and set the value to 1.
Unlock DBS-C01 to see the answer
You've previewed enough free DBS-C01 questions. Unlock DBS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.