You have configured GTID-based asynchronous replication with one master and one slave.
A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes. Examine the current GTID information:

You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover. Which set of actions would allow the slave to continue replicating without erroneous transactions?

• A. RESET SLAVE;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
  SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10300;
• B. RESET SLAVE;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• C. RESET MASTER;
  SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
  SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• D. RESET MASTER;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• E. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb- bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9; SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

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

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

A user wants to connect without entering his or her username and password on the Linux command prompt.
Which three locations can be used to store the user's mysql credentials to satisfy this requirement? (Choose three.)

• A. $HOME/.mysqlrc file
• B. $HOME/.mylogin.cnf file
• C. $HOME/.my.cnf file
• D. DATADIR/mysqld-auto.cnf file
• E. /etc/my.cnf file
• F. $MYSQL_HOME/my.cnf file
• G. $HOME/.mysql/auth/login file

You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave:

Which statement is true?

• A. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
• B. Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbb GTIDs in its binary logs.
• C. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
• D. Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-cccccccccccc GTIDs.
• E. Replication will work.

Which four connection methods can MySQL clients specify with the --protocol option when connecting to a MySQL server? (Choose four.)

• A. PIPE
• B. IPv6
• C. TCP
• D. SOCKET
• E. FILE
• F. DIRECT
• G. MEMORY
• H. IPv4