Examine these statements and output: mysql> GRANT PROXY ON accounting@localhost TO ' '@'%' ; mysql> SELECT USER(), CURRENT_USER(), @@proxy_user; Which statement is true?

User `fwuser`@`localhost` is registered with the MySQL Enterprise Firewall and has been granted 

privileges for the SAKILA database. 

Examine these commands that you executed and the results: 

mysql> SELECT MODE FROM INFORMATION_SCHEMA.MYSQL_FIREWALL_USERS 

WHERE USERHOST = 'fwuser@localhost' ; 

mysql> SELECT RULE FROM 

INFORMATION_SCHEMA.MYSQL_FIREWALL_WHITELIST 

WHERE USERHOST = 'fwuser@localhost'; 

You then execute this command: 

mysql> CALL mysql.sp_set_firewall_mode('fwuser@localhost' , 'RESET') ; 

Which two are true?

A newly deployed replication master database has a 10/90 read to write ratio. 

The complete dataset is currently 28G but will never fluctuate beyond +-10%. 

The database storage system consists of two locally attached PCI- E Enterprise grade disks 

(mounted as /data1 and /data2) 

The server is dedicated to this MySQL Instance. 

System memory capacity is 64G. 

The my.cnf file contents are displayed here: 

[mysqld] 

datadir=/data1/ 

innodb_buffer_pool_size=28G 

innodb_log_file_size=150M 

Which four changes provide the most performance improvement, without sacrificing data 

integrity? 

You are having performance issues with MySQL instances. Those servers are monitored with 

MySQL Enterprise Monitor. 

Using Query Analyzer, where do you begin to look for problem queries?

Choose two.

Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure?