Examine this output: 

mysql> SHOW GLOBAL VARIABLES LIKE '%dir'; 

+--------------------------------------+--------------------------------+

 |Variable_ name |Value |basedir |/usr | 。。。。。。 |datadir |/var/lib/mysql | |innodb data_ home dir |/ innodb data | |innodb log_ group home_ di r |./ | |innodb temp tablespaces_ di I |./#innodb temp/ | |innodb tmpdir | | 。。。。。。 |plugin dir|/usr/ lib/plugin | 。。。。。。。 |tmpdi z ||/ tmp: /var/ tmp | 

+------------------------------------------------+---------------------+

 You plan to add this parameter to the configuration:

 innodb_ directories=‘ /innodb_ extras’ 

Which statement is true?

Examine this client error: 

ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/local/mysql/lib/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory 

Which option will allow this client to connect to MySQL Server?

 [mysqld] user=mysql datadir=/data/mysql 

Which method sets the default authentication to SHA-256 hashing for authenticating user account passwords?

Your MySQL environment has asynchronous position based-replication with one master and one slave. The slave instance had a disk I/O problem, so it was stopped. You determined that the slave relay log files were corrupted and unusable, but no other files are damaged. You restart MySQL Server. How can replication be restored?

Examine this command: 

shell> mysqldump --no-create-info --all-databases --result-file=dump.sql 

Which statement is true?

MySQL Enterprise Monitor Query Analyzer is configured to monitor an instance. 

Which statement is true?

Examine this command, which executes successfully: 

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

Which activity is performed?

Four nodes are configured to use circular replication. Examine these configuration parameters for each each node:

 slave_parallel_type=DATABASE ; slave_parallel_workers=4 slave_preserve_commit_order=0 

Which statement is true?

shell> mysqld --initialize 

Which statement is true?

You have configured a working MySQL InnoDB Cluster in single-primary mode. What happens when the primary instance goes down due to a network problem?

$ mysqlbackup --user=dba --password --port=3306 --with-timestamp --only-known-file-types --backup-dir=/export/backups backup 

Which statement is true?