
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.
E. Provide users access to the server's private key.
Answer: B
NO.2 A master-slave replication setup has the slave showing this error:
On the master server, the binary logs show:
What could explain this error? (Choose two.)
A. binlog_cache_size=1024 is too small and transactions are lost.
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
C. the mysql_secure_installation script to update server security settings
D. the mysql client with the --enable-cleartext-plugin option
E. the install plugin command for the mysql_cleartext_password plugin
Answer: C
Reference: http://planet.mysql.com/entry/?id=34077
IT Certification Guaranteed, The Easy Way!
2
评论