These details are shown when logged in to an account:

Which set of statements would match the accounts shown?

• A.mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets'; mysql> CREATE USER ''@'' IDENTIFIED BY 'valid_password' WITH PROXY
  'employee'@'localhost';
• B.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 ''@'';
• C.mysql> CREATE USER 'robert'@'localhost' IDENTIFIED BY 'secret_password'; mysql>CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';
• D.mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets'; mysql> GRANT PROXY ON 'employee'@'localhost' TO 'robert'@'localhost';

Comment: *

Name: *

Email: *

Verification: *

A MySQL Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain this additional configuration:

The MySQL Server is restarted without error.
What effect will the new configuration have on existing account?

• A.They are not affected by this configuration change.
• B.They will have their passwords updated on start-up to sha256_passwordformat.
• C.They will have to change their password the next time they login to the server.
• D.They all connect via the secure sha256_passwordalgorithm without any configuration change.

Comment: *

Name: *

Email: *

Verification: *

MySQL is installed on a Linux server and has this configuration:
[mysqld]
user=mysql
datadir=/data/mysql/
As the 'root' user, you change the datadir location by executing:
shell> cp -R /var/lib/mysql /data/mysql/
shell> chown -R mysql /data/mysql
What is the purpose of changing ownership of datadir to the 'mysql' user?

• A.MySQL cannot be run as the root user.
• B.MySQL requires correct file ownership while remaining secure.
• C.MySQL needs to be run as the root user, but files cannot be owned by it.
• D.The mysqld process requires all permissions within datadir to be the same.

Comment: *

Name: *

Email: *

Verification: *

You are using replication and the binary log files on your master server consume a lot of disk space.
Which two steps should you perform to safely remove some of the older binary log files? (Choose two.)

• A.Execute the PURGE BINARY LOGS NOT USEDcommand.
• B.Edit the .indexfile to remove the files you want to delete.
• C.Ensure that none of the attached slaves are using any of the binary logs you want to delete.
• D.Remove all of the binary log files that have a modification date earlier than today.
• E.Use the command PURGE BINARY LOGSand specify a binary log file name or a date and time to remove unused files.

Comment: *

Name: *

Email: *

Verification: *

Which two capabilities are granted with the SUPER privilege? (Choose two.)

• A.allowing client accounts to take over the account of another user
• B.allowing a client to kill other client connections
• C.allowing a client to shut down the server
• D.allowing change of the server runtime configuration

Comment: *

Name: *

Email: *

Verification: *