AWS Certified Database – Specialty — Question 156

A Database Specialist modified an existing parameter group currently associated with a production Amazon RDS for SQL Server Multi-AZ DB instance. The change is associated with a static parameter type, which controls the number of user connections allowed on the most critical RDS SQL Server DB instance for the company. This change has been approved for a specific maintenance window to help minimize the impact on users.
How should the Database Specialist apply the parameter group change for the DB instance?

Answer options

• A. Select the option to apply the change immediately
• B. Allow the preconfigured RDS maintenance window for the given DB instance to control when the change is applied
• C. Apply the change manually by rebooting the DB instance during the approved maintenance window
• D. Reboot the secondary Multi-AZ DB instance

Correct answer: C

Explanation

The correct answer is C because rebooting the DB instance during the approved maintenance window allows the changes to take effect without causing disruptions to users. Option A is incorrect as immediate application is not suitable for static parameters requiring a reboot. Option B does not specify that manual intervention is necessary, and Option D is irrelevant since changes need to be applied to the primary instance, not the secondary.