MySQL 8.0 Database Administrator — Question 131

Examine this parameter setting:
audit_log=FORCE_LOG_PERMANENT
What effect does this have on auditing?

Answer options

• A. It will force the load of the audit plugin even in case of errors at server start.
• B. It causes the audit log to be created if it does not exist.
• C. It prevents the audit plugin from being removed from the running server.
• D. It prevents the audit log from being removed or rotated.

Correct answer: C

Explanation

The correct answer is C because setting audit_log=FORCE_LOG_PERMANENT ensures that the audit plugin remains active and cannot be removed while the server is running. Options A and B are incorrect as they pertain to loading and creating the audit log, which are not affected by this specific setting. Option D is also incorrect because the setting specifically relates to the plugin's removal, not the log's retention or rotation policies.