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)?
Click on the arrows to vote for the correct answer
A. B. C. D. E.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.LocalTimeZoneThe RDS DBA changed the time zone of a MariaDB RDS instance by setting the dynamic parameter "time_zone" in the DB Parameter Group to the local time zone of the application. However, an application user is still reporting an incorrect time zone, which indicates that there may be some issues with the time zone configuration.
To resolve the issue, the DBA should perform the following two actions:
Ensure that the DB Parameter Group is applied to the RDS instance The first step is to ensure that the DB Parameter Group is applied to the RDS instance. The DB Parameter Group contains a set of parameters that control the behavior of the database engine. The DBA should verify that the DB Parameter Group is applied to the RDS instance and that the "time_zone" parameter is set to the correct value.
Use rdsadmin.rdsadmin_util.alter_db_time_zone procedure to update the RDS instance time zone to value set in the DB Parameter Group. If the DB Parameter Group is applied to the RDS instance and the "time_zone" parameter is set to the correct value, the DBA should use the rdsadmin.rdsadmin_util.alter_db_time_zone procedure to update the RDS instance time zone. This procedure updates the time zone of the RDS instance and all the databases within it. The DBA should ensure that the new time zone is set to the value specified in the DB Parameter Group, which is the local time zone of the application.
Instructing the application developers to update the application code to use the dynamic parameter type for the "time_zone" parameter may not be necessary as the DBA has already set the parameter in the DB Parameter Group. Rebooting the RDS DB instance or instructing the application user to disconnect and start a new session may not resolve the issue as the problem is related to the time zone configuration, and these actions are unlikely to affect the time zone settings.