An RDS DBA changes the time zone of a Maria DB RDS Instance by setting the dynamic parameter time_zone in the DB Parameter Group to the local time zone of the application. An application user is still reporting an incorrect time zone. What actions should the DBA perform to resolve the issue (choose two)?

Answer options:

A.Ensure that the DB Parameter Group is applied to the RDS instance.
B.Instruct the application developers to update the application code to use the dynamic parameter type for the time_zone parameter.
C.Reboot the RDS DB instance.
D.Instruct the application user to disconnect from the database and start a new session.
E.Use rdsadmin.rdsadmin_util.alter_db_time_zone procedure to update the RDS instance time zone to value set in the DB Parameter Group.

Answer: A and D
Option A is CORRECT because the custom DB Parameter Group where the time_zone parameter was set must be applied to the RDS instance.
Option B is incorrect because application code change is not necessary when the time zone on the database has been changed.
Option C is incorrect because dynamic parameters in DB parameter groups do not require RDS instance reboot.
Option D is CORRECT because the time zone change takes effect on any new sessions to the database.Any open connections to the database will use the session time zone.To resolve the issue, the user must close the current connection and open a new connection.
Option E is incorrect because the rdsadmin.rdsadmin_util.alter_db_time_zone procedure is used to set the time zone of an Oracle DB instance.
Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_MariaDB.html#MariaDB.Concepts.LocalTimeZone