1Z0-908 Exam Question 6

A MySQL server is monitored using MySQL Enterprise Monitor's agentless installation.
Which three features are available with this installation method? (Choose three.)
  • 1Z0-908 Exam Question 7

    An attempt to recover an InnoDB Cluster fails.
    Examine this set of messages and responses:
    host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage() Reconfiguring the default cluster from complete outage...
    The instance 'host1:3377'' was part of the cluster configuration. Would you like to rejoin it to the cluster?
    [y/N]: y
    The instance 'host2:3377' was part of the cluster configuration. Would you like to rejoin it to the cluster?
    [y/N]: y
    Dba.rebootClusterFromCompleteOutage: The active session instance isn't the most updated in comparison with the ONLINE instances of the Cluster's metadata. Please use the most up to date instance: 'host1:3377'.
    (RuntimeError)
    Which statement is true?
  • 1Z0-908 Exam Question 8

    The mysqld instance has the connection control plugin enabled with these settings:
    connection_control_min_connection_delay=1000 connection_control_max_connection_delay=2000 The minimum and maximum delays need to be increased to 3000 and 5000, respectively.
    A command is executed:
    mysql> SET GLOBAL connection_control_min_connection_delay=3000;
    What is the result?
  • 1Z0-908 Exam Question 9

    Which two MySQL Server accounts are locked by default? (Choose two.)
  • 1Z0-908 Exam Question 10

    Examine these commands and output:

    Which connection ID is holding the metadata lock?