MySQL85题版本1z0-888.pdf

NO.1 To satisfy a security requirement, you have created or altered some user accounts to include

REQUIRE X509.

Which additional task needs to be performed for those user accounts to fulfill the requirement to use

X509?

A. Install the X509 plug-in on the server.

B. Set the X509 option in the [client] section of the MySQL server's configuration file.

C. Restart the server with the --require-x509 option.

D. Distribute client digital certificates to the client computers being used to log in by the user

accounts.

B. binlog_format=STATEMENT and a non-deterministic query was executed.

C. enforce_gtid_consistency=ON and consistency is broken between the master and the slave.

D. The sync_relay_log=1000 setting on the slave is too small.

E. sync_binlog=0 and the master server crashed.

Answer: A,C

NO.3 You attempt to connect to a MySQL Server by using the mysql client program. However, you

receive this notice:

What would you run to fix the issue?

A. the mysql_upgrade script

B. the mysql client with the --ignore-password-hashing option

2

NO.4 You are using the Performance Schema to investigate replication on a slave which has a single

master. The option slave-parallel-type is set to DATABASE.

Assume that all instruments and consumers are enabled and all threads are instrumented.

Which two facts can be concluded from the given output?

A. The salve has two intermediate relay slaves connected to it.

B. The slave is configured with slave_parallel_workers = 4

C. At most, two schemas are being updates concurrently.

D. THREAD_ID 21 has stopped running.

E. The slave cannot process the relay log fast enough to use all threads.

Why does the command fail?

A. max_connections requires the GLOBAL scope.

B. Its current user does not have the SUPER privilege.

C. max_connections is not a dynamic variable. You need to change the config file and restart the

database.

3

D. Users can control only the max_user_connections variable.

Answer: A

NO.6 You have a consistent InnoDB backup created with mysqldump, the largest table is 50 GB in

size.

You start to restore your backup with this command;

shell> mysql -u root -p < backup.sql

interrupted mid-way.

D. InnoDB has filled the redo log and now must flush the pages.

E. Secondary indexes no longer fit into the buffer pool.

Answer: A

NO.7 After analysis on the slow query log on a high-end OLTP service, the table identified in the slow

queries is:

What are the two most likely reasons for the slowness given this output?

A. Date should be a TIMESTAMP field for better performance.

B. The User field is too long for most names.

C. The engine type is not appropriate to the application use.

4

A. validate_password_policy cannot be set without restarting the MySQL instance.

B. The name of the dictionary file is too obvious.

C. The dictionary file word list is too short.

D. validate_password_dictionary_file cannot be set without restarting the MySQL instance.

E. The validate_password plug-in has not been loaded.

F. The dictionary file is an insecure location.

Answer: B,F

NO.9 These details are shown when logged in to an account:

Which set of statements would match the accounts shown?

5

'employee'@'localhost' IDENTIFIED BY 'more_secrets';

D. mysql> CREATE_USER ''@'' IDENTIFIED WITH authentication_pam ACCOUNT

LOCK;

mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets'; mysql> GRANT PROXY

ON 'employee'@'localhost' TO ''@'';

Answer: D

NO.10 You have a MySQL instance with the following variables in the /etc/my.cnf file:

You issue these statements:

USE prices;

B. The changes caused by the UPDATE statement are logged to the binary log because the instance is

using --binlog-format = ROW

C. The statement would fail because you cannot update more than one row at a time when using -

binlogformat = ROW.

D. Nothing is logged because you are executing an UPDATE statement that will cause changes to

more than one row, and you do not have the --binlog-format value set to STATEMENT.

E. Nothing was written to the binary log because you cannot perform a calculation in a query without

enclosing the statement in single quotation marks.

Answer: D,E

NO.11 On a master server that is using statement-based replication, a table of log data has become

6