Examine this command and output:

Which statement is true?

• A.Firewall_access_denied is the number of connection attempts from prohibited hosts that are denied.
• B.Firewall_access_suspicious is the number of statements logged as suspicious for users in DETECTING mode.
• C.Firewall_access_granted is the number of connections granted from whitelisted hosts.
• D.Firewall_cached_entries is the number of statements found in the query cache for users in DETECTING mode.

Comment: *

Name: *

Email: *

Verification: *

What does the binlog dump thread do?

• A.It acquires a lock on the binary log for reading each event to be sent to the slave.
• B.It monitors and schedules the rotation/deletion of the binary logs.
• C.It connects to the master and asks it to send updates recorded in its binary logs.
• D.It reads the relay log and executes the events contained in them.

Comment: *

Name: *

Email: *

Verification: *

You want to log only the changes made to the database objects and data on the MySQL system.
Which log will do this by default?

• A.error log
• B.general query log
• C.slow query log
• D.audit log
• E.binary log

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

MySQL is installed on a Linux server with this configuration:

Which method sets the default authentication to SHA-256 hashing for authenticating user account passwords?

• A.Set validate-user-plugins=caching_sha2_password in the configuration file.
• B.Add default_authentication_plugin=mysql_native_password in the configuration file.
• C.Add default_authentication_plugin=sha256_password in the configuration file.
• D.Define CREATE USER ''@'%' IDENTIFIED WITH sha256_password in the MySQL instance.

Comment: *

Name: *

Email: *

Verification: *