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/.mysql/auth/login file
• C.DATADIR/mysqld-auto.cnf file
• D.$MYSQL_HOME/my.cnf file
• E.$HOME/.my.cnf file
• F.$HOME/.mylogin.cnf file
• G./etc/my.cnf file

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about MySQL replication? (Choose three.)

• A.Binary logging must be enabled on the master in order to replicate to other instances.
• B.Any instance can have multiple slaves, but it can have only one master.
• C.Binary logs contain only transactions originating from a single MySQL instance.
• D.Each slave must have its own MySQL user for replication.
• E.A replication user must have the SELECT privilege for all tables that need to be replicated.
• F.Each instance in a replication topology must have a unique server ID.
• G.Replication can use only TCP/IP connections.

Comment: *

Name: *

Email: *

Verification: *

A MySQL server is monitored using MySQL Enterprise Monitor's agentless installation.
Which three features are available with this installation method? (Choose three.)

• A.operating system memory utilization
• B.MySQL Query Analysis data
• C.network-related information and network characteristics
• D.security-related advisor warnings
• E.disk usage and disk characteristics including disk advisors warnings
• F.MySQL Replication monitoring
• G.CPU utilization

Comment: *

Name: *

Email: *

Verification: *

Examine this statement and output:

You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)

• A.QN = 1
• B.QN = 2
• C.QN = 4
• D.QN = 5
• E.QN = 3

Comment: *

Name: *

Email: *

Verification: *

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 metadat a. Please use the most up to date instance: 'host1:3377'. (RuntimeError) Which statement is true?

• A.The instance deployed on host3 must be rebuilt with a backup from the primary instance.
• B.The active session instance is invalid and must be re-created by using the command shell.connect ('host3:3377').
• C.The cluster is running and there is at least one ONLINE instance.
• D.It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET(set1,set2).
• E.The instance deployed on host3 must be synchronized from a donor deployed on host1 by using the command cluster.addInstance('host1:3377').

Comment: *

Name: *

Email: *

Verification: *