MySQL Replication Environment (Master and Slave) is prepared. What are the two options for connecting a Java application to the MySQL Master and Slave?

• A. Use MySQL Router with the following configuration:[DEFAULT]logging_folder=
  /var/log/mysqlrouter[logger]level=INFO[routing: failover]bind_port =
  7001mode=replicationdestinations=master:3306, slave:3306The Java application can connect to bind_port=7001
• B. Use MySQL Router with the following
  configuration:[DEFAULT]logging_folder=/var/log/mysqlrouter[logger]level=INFO[routing:
  failover]bind_port = 7001mode=read-writedestinations= master:3306, slave:3306The Java application can connect to bind_port=7001.
• C. The default JDBC driver is automatically configured with High Availability Option by pointing the connection URL to any one of the MySQL instances.
• D. Use MySQL Connector/J with the com.mysql.jdbc.ReplicationDriver with JDBC URL asjdbc:mysql:replication://[mater host] [:port], [slave host 1] [:port] [, [slave host 2] [:port]] ...
  [/[database]] [? propertyName=propertyValue1 [&propertyName2-propertyValue2]...]

You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise Monitor (MEM). How would you proceed?

• A. Sort the "Exec" column and check for SQL queries with low QRTi values.
• B. Sort the "Exec" column and check for SQL queries with high QRTi values.
• C. Look for queries with low total latency times in the Latency section in the times series graph (Query Analyzer.)
• D. Look for queries with big prolonged spikes in row activity/access graph in the times series graph (Query Analyzer.)

You have the MySQL 5.7 database running. MySQL Enterprise Backup 3.12 is installed and it is used to back up the MySQL 5.7 database. The backup has failed. Identify the reason.

• A. mysqlbackup with MySQL Enterprise Backup 3.x must be executed once with the - -upgrade on MySQL 5.7 database to allow the mysql.backup_progress and mysql.backup_history tables to be patched.
• B. MySQL 5.7 is supported in MySQL Enterprise Backup 3.x providing that the MySQL 5.7 is pre-registered in the MySQL Enterprise Backup configuration file.
• C. MySQL Workbench must be installed with MySQL Enterprise Backup to enable the backup to run successfully.
• D. MySQL Enterprise Backup 3.x does not support MySQL 5.7. MySQL Enterprise Backup 4.x or later is required to back up MySQL 5.7.
• E. MySQL 5.7 is supported in MySQL Enterprise Backup 3.x with the MySQL 5.7 extension pack.

The MySQL pluggable authentication plug-in for Windows is enabled and configured. The following command is executed on a MySQL Server:
CREATE USER 'SQL_admin'@'%' IDENTIFIED WITH authentication_windows AS 'joe, henry, "Power Users"'; Which two statements are valid?

• A. User Joe may log in to a Windows Client and then access the MySQL Server from a MySQL Client without being asked about a password.
• B. When any of the named users is using a Java application based on his or her Windows Client, no authentication is necessary to log in to MySQL.
• C. Logins are granted only if the user's client application and the corresponding MySQL instance are on the same IP address.
• D. When any of the named users is using a Linux Client, the user can access the MySQL Server from s MySQL Client with the password configured in the Windows Active Directory.
• E. When any of the named users is using a Linux Client, the user can access the MySQL Server from a MYSQL Client with the password configured in MySQL.