A database specialist is creating a new parameter group for an Amazon RDS database instance.
What property do parameters of type “static” have?
Click on the arrows to vote for the correct answer
A. B. C. D.Answer: C.
Static parameters require a manual reboot of the Amazon RDS instance before they are applied.
Dynamic parameters do not require a manual reboot and are applied immediately.
Therefore, Option C is CORRECT, and all other options are incorrect.
Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithParamGroups.htmlIn Amazon RDS, parameter groups are used to manage database engine configurations for RDS database instances. They contain a set of parameters that specify how the database engine behaves.
There are two types of parameters in an RDS parameter group: dynamic and static.
Dynamic parameters are those that can be modified without the need for a reboot. Changes to dynamic parameters take effect immediately after they are applied to the parameter group.
Static parameters, on the other hand, are those that cannot be modified once they are set. If you need to modify a static parameter, you must create a new parameter group with the new value.
In the context of the given question, parameters of type "static" cannot be modified once they are set, so answer A is correct. Additionally, because static parameters cannot be modified, they do not require a reboot to take effect. Therefore, answer D is also correct.
It's important to note that some parameter changes, even if they are dynamic, may require a reboot to take effect. When a parameter change requires a reboot, it is noted in the RDS console and documentation.