A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)

A. binlog_cache_size=1024 is too small and transactions are lost.

B. binlog_format=STATEMENT and a non-deterministic query was executed.

C. enforce_gtid_consistency=ON and consistency is broken between the master and the slave.

D. The sync_relay_log=1000 setting on the slave is too small.

E. sync_binlog=0 and the master server crashed.

Which statement is true about using Microsoft Windows Cluster as a platform for MySQL?

A. It relies on the shared disk architecture being visible to both servers.

B. It is provided by means of IP-level disk replication.

C. It implements High Availability by using the .NET Connector's load balancing capabilities.

D. It is a shared-nothing architecture.

You want to immediately stop access to a database server for remote user `mike'@'client.example.com'. This user is currently not connected to the server.

Which two actions can you take to stop any access from the user?

A. Use ALTER USER `mike'@'client.example.com' PASSWORD EXPIRE;

B. Use REVOKE ALL PRIVILEGES FROM `mike'@'client.example.com';

C. Execute the mysql_secure_installation command.

D. Use DROP USER `mike'@'client.example.com';

E. Use GRANT USAGE ON *.* TO `mike'@'client.example.com' MAX_USER_CONNECTIONS=0;

F. Use ALTER USER `mike'@'client.example.com' ACCOUNT LOCK;

Where does MySQL Linux RPM install the mysqld binary?

A. /usr/libexec/

B. /usr/local/mysql/bin/

C. /usr/sbin/

D. /usr/bin/

E. /opt/mysql/server/bin/

The MySQL user `adam' currently has USAGE permissions to the database.

The football database is transactional and has non-stop updates from application users. The `adam' user needs to be able to take consistent backups of the football database by using the ?single-transaction option.

Which extra GRANT permissions are required for adam to take mysqldump backups?

A. The `adam' user must also have SINGLE TRANSACTION global grant to take a consistent backup.

B. The `adam' user needs the PROCESS privilege to be able to take a consistent backup while other users are connected.

C. The `adam' user must have the SUPER privilege in order to take data backups.

D. The `adam' user must also have SELECT on the football database for backup to work.