Question 6

Exhibit:

What does the possible_keys column in this output denote?
  • Question 7

    What is the best method for monitoring Group Replication conflict resolution?
  • Question 8

    You are using GTIDSin replication. You need to skip a transaction with the GTIDof aaa-bbb-ccc-ddd- eee:3on a slave.
    Which procedure would you execute from a MySQL prompt?
  • Question 9

    Which two methods accurately monitor the size of your total database size over time? (Choose two.)
  • Question 10

    Due to an authentication plug-in that is used on the server, passwords are required to be sent as clear text as opposed to the usual encrypted format.
    Which two methods would allow the mysqlclient to connect to the server and send clear text passwords?
    (Choose two.)