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.)
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?
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?
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?

Which connection ID is holding the metadata lock?
