Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

Examine this SQL statement:

mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;

Which two are true? (Choose two.)

A.

Mark can grant the privileges assigned to the r_read@localhost role to another user.

B.

ADMIN OPTION causes the role to be activated by default.

C.

Mark can grant the r_read@localhost role to another user.

D.

Mark can revoke the r_read@localhost role from another role.

E.

ADMIN OPTION allows Mark to drop the role.

F.

Mark must connect from localhost to activate the r_read@localhost role.

You must configure the MySQL command-line client to provide the highest level of trust and security when connecting to a remote MySQL Server.

Which value of --ssl-mode will do this?

A.

PREFERRED

B.

VERIFY_CA

C.

REQUIRED

D.

VERIFY_IDENTITY

You plan to install MySQL Server by using the RPM download.

Which two statements are true? (Choose two.)

A.

You can provide the root password interactively.

B.

You must manually initialize the data directory.

C.

The MySQL RPM package installation supports deploying multiple MySQL versions on the same host.

D.

MySQL uses the RPM relocatable installation target feature.

E.

The functionality is split among several RPM package files.

F.

You can find the root password in the error log after the first start.

Your MySQL server is running on the Microsoft Windows platform.

Which three local connection protocols are available to you? (Choose three.)

A.

named pipes

B.

shared memory

C.

SOCKET

D.

X Protocol

E.

UDP

F.

TCP/IP

You have a MySQL client installed on your Linux workstation with a default installation. You have your admin login credentials to connect to a MySQL server running Microsoft Windows on remote host 192.0.2.1:3306. You wish to connect directly to the world database.

Which four options need to be specified to complete this task with a single command? (Choose four.)

A.

--shared-memory-base-name=world

B.

--protocol=UDP

C.

--protocol=pipe

D.

--password

E.

--user=admin

F.

--host=192.0.2.1

G.

--socket=/tmp/mysql.sock

Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)

A.

dba.configureInstance()

B.

cluster.setPrimaryInstance()

C.

dba.configureLocalInstance()

D.

cluster.forceQuorumUsingPartitionOf()

E.

cluster.addInstance()

F.

dba.createCluster()

G.

dba.checkInstanceConfiguration()

Examine this query and its output:

Which two statements are true? (Choose two.)

A.

The root user had the largest number of modified rows for a SELECT statement.

B.

User bob had the largest total time waiting for locks.

C.

The root user had the largest single wait time.

D.

The app user had the highest total number of rows read from storage engines.

E.

User bob had a significantly higher ratio of SELECT + INSERT statements to QUIT than both app and root users.

A clean shutdown was performed with innodb_fast_shutdown=0.

While you were manipulating files, all files were accidentally deleted from the top-level data directory.

Which two files must be restored from backup to allow the DB to restart cleanly? (Choose two.)

A.

ibtmp1

B.

undo_001

C.

ib_buffer_pool

D.

ibdata1

E.

mysql.ibd

F.

ib_logfile0

Which statement is true about displaying and retrieving data with MySQL Enterprise Monitor Query Analyzer?

A.

The Query Analyzer graph view range selector can extend to cover the same hour over multiple days.

B.

It is possible to filter a Query Analyzer view graph by database and by table.

C.

The Query Analyzer can plot a CPU utilization graph for remote hosts with a MySQL Enterprise Service Manager's built-in Agent installation.

D.

It is possible to export statements included in a graph selection in CSV format.

You have upgraded the MySQL binaries from 5.7.28 to 8.0.18 by using an in-place upgrade.

Examine the message sequence generated during the first start of MySQL 8.0.18:

Which step or set of steps will resolve the errors?

A.

Remove the redo logs. Replace the MySQL binaries with the 5.7.28 binaries. Prepare the tables for upgrade. Upgrade to 8.0.18 again.

B.

Execute: mysqlcheck --check-upgrade mysql columns_priv event proc proxies_priv tables_priv.

C.

Start mysqld again using the --upgrade=FORCE option.

D.

Execute: mysqlcheck --repair mysql columns_priv event proc proxies_priv tables_priv.

E.

Go to the /mysql directory and execute: myisamchk --update-state columns_priv event proc proxies_priv tables_priv.