1z1-908 試験問題を無料オンラインアクセス

MySQL programs look for option files in standard locations.
Which method will show the option files and the order in which they are read?

• A.shell> mysqld --help --verbose
• B.shell> mysql --print-defaults
• C.mysql> SHOW GLOBAL VARIABLES;
• D.shell> mysqladmin --debug

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

• A.It is possible to export statements included in a graph selection in CSV format.
• B.It is possible to filter a Query Analyzer view graph by database and by table.
• C.The Query Analyzer graph view range selector can extend to cover the same hour over multiple days.
• D.The Query Analyzer can plot a CPU utilization graph for remote hosts with a MySQL Enterprise Service Manager's built-in Agent installation.

Which command enables rule-based MySQL Auditing capabilities?

• A.mysql> INSTALL PLUGIN audit_log;
• B.shell> mysqld --initialize --log-raw=audit.log
• C.shell> mysql < audit_log_filter_linux_install.sql
• D.mysql> INSTALL COMPONENT audit_log;

Examine these statements and output:

Which statement is true?

• A.The user is authorized as the rsmith@localhost user.
• B.The user is authenticated as the anonymous proxy user ''@'%'.
• C.The user is logged in with --user=accounting as an option.
• D.The user failed to define a username and the connecting username defaulted to ''@'%'.
• E.The user is authorized as the accounting@localhost user.

Examine this command, which executes successfully:
$ mysqlrouter --bootstrap user@hostname:port --directory=directory_path Which activity is performed?

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