AWS Certified Database – Specialty — Question 223

A company has a Microsoft SQL Server 2017 Enterprise edition on Amazon RDS database with the Multi-AZ option turned on. Automatic backups are turned on and the retention period is set to 7 days. The company needs to add a read replica to the RDS DB instance.

How should a database specialist achieve this task?

Answer options

• A. Turn off the Multi-AZ feature, add the read replica, and turn Multi-AZ back on again.
• B. Set the backup retention period to 0, add the read replica, and set the backup retention period to 7 days again.
• C. Restore a snapshot to a new RDS DB instance and add the DB instance as a replica to the original database.
• D. Add the new read replica without making any other changes to the RDS database.

Correct answer: D

Explanation

The correct answer is D because adding a read replica can be done directly without any modifications to the current Multi-AZ setup or backup retention settings. Options A and B incorrectly suggest changes that are unnecessary and could disrupt the database's operational integrity. Option C involves restoring a snapshot, which is not required for creating a read replica in this scenario.