Oracle 1z0-908 - MySQL 8.0 Database Administrator
Which two are valid uses for binary logs on a MySQL instance? (Choose two.)
An existing asynchronous replication setup is running MySQL 8.
Which two steps are a part of implementing GTID replication? (Choose two.)
Which two statements are true about using MySQL Enterprise Monitor Query Analyzer? (Choose two.)
Which two methods allow a DBA to reset a user's password? (Choose two.)
You are using an existing server with a new configuration. MySQL Server fails to start.
Examine this snapshot of the error log:
Which action would allow the server to start?
Examine these InnoDB Cluster parameter settings:
Now examine the partial status:
A permanent network failure isolates host3.
Which two statements are true? (Choose two.)
You have replication configured, which consists of one master and one slave on different hosts with an asynchronous replication channel between them.
Your goal is to decrease the amount of data that is transferred between these two hosts.
It is confirmed that the slave instance does not need to have data from the example database.
Which replication filter contributes to your goal?
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?
You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)
Examine this SQL statement:
Which set of privileges will allow Tom to execute this SQL statement?