AWS Certified Database – Specialty — Question 130

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.)

Answer options

• A. Identify a potential downtime window and stop the application calls to the source DB instance.
• B. Ensure that automatic backups are enabled for the source DB instance.
• C. Ensure that the source DB instance is a Multi-AZ deployment with Always ON Availability Groups.
• D. Ensure that the source DB instance is a Multi-AZ deployment with SQL Server Database Mirroring (DBM).
• E. Modify the read replica parameter group setting and set the value to 1.

Correct answer: B, C

Explanation

The correct answers, B and C, are essential because automatic backups must be enabled for creating a read replica, and the source DB instance must be a Multi-AZ deployment with Always ON Availability Groups to support read replicas. Options A, D, and E are incorrect because stopping application calls is not necessary, SQL Server Database Mirroring is not a requirement for read replicas, and modifying the parameter group settings is not a prerequisite for creating the read replica.