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

Comment: *

Name: *

Email: *

Verification: *

At which stage during query processing does MySQL create a query's execution plan?

• A.Optimizing
• B.Parsing
• C.Executing
• D.Authorizing

Comment: *

Name: *

Email: *

Verification: *

The MySQL installation includes the mysql_config_editor utility for managing login paths stored in a .mylogin.cnf file.
Which two are true about the login path feature? (Choose two.)

• A.A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.
• B.It provides means to help avoid accidentally exposing the MySQL login details.
• C.It is an alternative to storing the MySQL login details in a my.cnf file.
• D.A .mylogin.cnf file can store at most one login path.
• E.mysql_config_editor is the only MySQL-provided utility that can print the values stored in .mylogin.cnf.
• F.It provides a FIPS-compliant keyring for storing MySQL login details.

Comment: *

Name: *

Email: *

Verification: *

An admin attempts to enforce stronger security by using these commands:

The admin then leaves the system running with the specified changes. What are two remaining security concerns?

• A.The dictionary file word list is too short.
• B.The name of the dictionary file is too obvious.
• C.validate_password_policy cannot be set without restarting the MySQL instance.
• D.The dictionary file is an insecure location.
• E.validate_password_dictionary_file cannot be set without restarting the MySQL instance.
• F.The validate_password plug-in has not been loaded.

Comment: *

Name: *

Email: *

Verification: *

Consider the key buffer in a MySQL server. Which two statements are true about this feature?

• A.It caches index blocks for MyISAM tables only.
• B.It caches index blocks for all storage engine tables.
• C.It is a global buffer.
• D.It is set on a per-connection basis.
• E.It caches index blocks for InnoDB tables only.

Comment: *

Name: *

Email: *

Verification: *