QUESTION: 13

Examine this command, which executes successfully:

$ mysqlrouter --bootstrap user@hostname:port --directory=directory_path

Which activity is performed?

MySQL Router is configured based on the information in files in directory_path.
MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.
MySQL Router is restarted.
MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.

Answer(s): B

Reference:

https://dev.mysql.com/doc/mysql-router/8.0/en/mysqlrouter.html

Show Answer Next Question

You encountered an insufficient privilege error in the middle of a long transaction.

The database administrator is informed and immediately grants the required privilege:

GRANT UPDATE ON world.city TO `user1';

How can you proceed with your transaction with the least interruption?

Roll back the transaction and start the transaction again in the same session.
Re-execute the failed statement in your transaction.
Change the default database and re-execute the failed statement in your transaction.
Close the connection, reconnect, and start the transaction again.

Answer(s): B

Show Answer Next Question

QUESTION: 15

Examine these statements, which execute successfully:

CREATE ROLE r_world_rd;
GRANT SELECT ON world.* TO r_world_rd;
CREATE USER john IDENTIFIED BY `P@ssw0rd';
GRANT r_world_rd TO john;

Examine these statements issued by user John:

What is the reason for the error?