A DBA wishes to limit the number of simultaneous connections that a user account can make to 10 on a specific MySQL RDS Database. What method should the DBA use to accomplish this task?

Answer options:

A.Create a new DB parameter group. Modify the max_user_connections parameter to 10. Update the RDS MySQL Database to use the new DB parameter group.
B.Modify the default parameter group of the MySQL RDS Database by setting the max_user_connections parameter to 10.
C.Modify the default option group of the MySQL RDS Database by setting the max_user_connections parameter to 10.
D.Execute command SET max_user_connections=10;.

Answer: A
Option A is CORRECT because DB parameter groups need to be used to modify RDS DB parameters. To set a particular parameter, you must create a new DB parameter group and update the specific parameter (max_user_connections in this case).Then you must modify the RDS database instance to use the new DB Parameter group.
Option B is incorrect because you cannot modify the values of the default DB parameter group.
Option C is incorrect because option groups are not used for setting parameters. Option groups are used to enable and configure additional features provided by some DB engines.
Option D is incorrect because AWS RDS does not allow modification of MySQL system variables directly using the SET statement. Instead, DB parameter groups must be used.
Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithParamGroups.html