Which two statements are true about the mysqld-auto.cnf file? (Choose two.)

• A. This file is for storing MySQL Server configuration options in ISON format.
• B. It is read and processed at the end of startup configuration.
• C. It is always updated with changes to system variables.
• D. It is read and processed at the beginning of startup configuration.
• E. This file is for logging purposes only and is never processed.
• F. This file is for storing MySQL server_uuid values only.

There are five MySQL instances configured with a working group replication.
Examine the output of the group members:

Which two statements are true about network partitioning in the cluster? (Choose two.)

• A. A manual intervention to force group members to be only the working two instances is required.
• B. There could be both a 2 node and 3 node group replication still running, so shutting down group replication and diagnosing the issue is recommended.
• C. The cluster will shut down to preserve data consistency.
• D. The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.
• E. The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.

You must configure the MySQL command-line client to provide the highest level of trust and security when connecting to a remote MySQL Server.
Which value of --ssl-mode will do this?

• A. REQUIRED
• B. VERIFY_CA
• C. PREFERRED
• D. VERIFY_IDENTITY

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. general query log
• B. error log
• C. audit log
• D. binary log
• E. slow query log

User account baduser@hostname on your MySQL instance has been compromised.
Which two commands stop any new connections using the compromised account? (Choose two.)

• A. ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;
• B. ALTER USER baduser@hostname ACCOUNT LOCK;
• C. ALTER USER baduser@hostname DEFAULT ROLE NONE;
• D. ALTER USER baduser@hostname PASSWORD DISABLED;
• E. ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;