Which two statements are true about MySQL Enterprise Firewall?

• A. MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain.
• B. Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.
• C. On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.
• D. MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.
• E. The firewall functionality is dependent upon SHA-256 and ANSI-specific functions built in to the mysql.firewall table. These functions cannot be deleted, even by the root user.
• F. System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.

You want to prevent any unauthorized users from gaining access to the personal information of your employees, which is stored in the EMPLOYEE table in a MySQL database. How would you use the MySQL Enterprise Edition Firewall to prevent the following SQL injection attack from exposing the salaries of all your employees?
SELECT fl_name, salary FROM EMPLOYEE WHERE fl_name= 'JHacker' OR 1=1;

• A. Create a blacklist of the SQL commands, which would restrict access to the EMPLOYEE table by using the DETECTING mode.
• B. Create a whitelist of approved SQL commands by using the RECORDING mode, and enable protection by changing it to PROTECTION mode.
• C. Create a FIREWALL STORED PROCEDURE to block any external user from executing this SQL statement.
• D. Create a list of approved SQL users by using the INTERROGATION mode.

A MySQL server (Linux-based installation, Port 3306, default) needs to be monitored. The MySQL server and the MySQL Enterprise Monitor (MEM) are located in different security zones, which are protected with a firewall. Which port must be opened for MEM agentless monitoring?

• A. Port 21/tcp (ftp) from MySQL Enterprise Monitor to MySQL server
• B. Port 18443/tcp (Tomcat) from MySQL server to MySQL Enterprise Monitor
• C. Port 22/tcp (SSH) from MySQL Enterprise Monitor to MySQL server
• D. Port 3306/tcp (MySQL) from MySQL Enterprise Monitor to MySQL server

A MySQL 5.7 is monitored via 3306 without a MySQL agent (agentless installation).
Which two options are not available in such a setup in the MEM GUI?

• A. MySQL Query Analysis data.
• B. Security-related advisors warning (for example, password warnings and firewall warnings)
• C. MySQL Replication monitoring
• D. Disk usage and disk characteristics including disk advisors warnings
• E. Network-related information and network characteristics

You have installed MySQL 5.6.20 on Windows 2012. This MySQL Instance is monitored without an Enterprise Monitor Agent. You cannot see any MySQL queries. How can you enable this feature?

• A. Use UPDATE performance_schema.setup_consumers SET enabled = 'NO' WHERE name =
  'statements_digest';
• B. For query analyzing, it is mandatory to use a MySQL Enterprise Monitor agent on Windows 2012 Server.
• C. MySQL query analyzing is available only in MySQL Version 5.7 and later. You need a later version of MySQL
• D. Use UPDATE performance_schema.setup_consumers SET enabled = 'YES' WHERE name='statements_digest';