DBS-C01 Question #165: Real Exam Question with Answer & Explanation

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.

Explanation

Before a DB instance can serve as a source instance for replication, 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. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.ReadReplicas.html

No community discussion yet for this question.