How should the Database Specialist apply the parameter group change for the DB instance?
Select the option to apply the change immediately
Allow the preconfigured RDS maintenance window for the given DB instance to control when the change is applied
Apply the change manually by rebooting the DB instance during the approved maintenance window
Reboot the secondary Multi-AZ DB instance
Explanations:
Applying the change immediately would affect the production environment and potentially disrupt user connections. Since the change is approved for the maintenance window, it should not be applied immediately.
The change is for a static parameter, which cannot be applied automatically during the maintenance window unless a reboot is triggered. This option is not valid for the static parameter type.
Rebooting the DB instance during the approved maintenance window is the correct way to apply the change for a static parameter. Static parameters require a reboot to take effect, and doing so within the maintenance window minimizes user impact.
Rebooting only the secondary Multi-AZ DB instance is not sufficient because the change needs to be applied to the entire DB instance. Both instances (primary and secondary) must be rebooted.