Consider the Mysql Enterprise Audit plugin.
Which statement is true when you identify a connection event that has used external authentication?

• A. External authentication is managed through external auditing logs.
• B. There is no differentiation between native and external authentication events.
• C. The attribute "STATUS" is set to the string EXTERNAL_AUTH.
• D. The attribute "PRIV_USER" contains the username.
• E. The event type that is given in the attribute "NAME" is EXTERNAL_AUTH.
• F. The "PROXY_PRIV" user shows a username if external authentication is used.

What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?

• A. File system snapshots
• B. Mysqldump with - binary-data option
• C. Mysqlhotcopy
• D. Mysql Enterprise Backup
• E. Mysqldumpslow

Consider the following:
Mysql> EXPLAIN SELECT * FROM City WHERE Name = 'Jacksonville' AND CountryCode = 'USA' \G ******************************** 1. row ******************************** Id: 1 Select_type: SIMPLE Table: City Type: ref Possible_keys: name_country_index Key: name_country_index Ref: const, const Rows: 1 Extra: Using where
Which statement best describes the meaning of the value for the key_len column?

• A. It shows how many columns in the index are examined.
• B. It shows how many bytes will be used from each index row.
• C. It shows the total size of the index row.
• D. It shows the number of characters indexed in the key.

Consider the MySQL Enterprise Audit plugin,
You add the following lines to the my.cnf configuration tile:
[mysqld]
Plugin-load=audit_log.so
Audit-log=FORCE_PLUS_PERMANENT
You attempt to start up the MySQL service and notice that it fails to start.
Which two statements would explain why the service did not start?

• A. The audit_log.so library is in a location that is different from that defined by the plugin_dir option.
• B. The audit_log.so library is not an executable file.
• C. The audit log file does not exist in which to write audit events.
• D. The audit_log.so library does not exist.
• E. The audit plugin must be loaded dynamically by using the INSTALL PLUGIN command.
• F. FORCE_PLUS_PERMANENT is not valid for the audit-log option.

In a design situation, there are multiple character sets that can properly encode your data.
Which three should influence your choice of character set?

• A. Character set mapping index hash size
• B. Memory usage when working with the data
• C. Comparing the encoded data with similar columns on other tables
• D. Disk usage when storing data
• E. Syntax when writing queries involving JOINS