Question 96
You have successfully provisioned the latest MySQL 5.7 database instance on a physical host, to be added to an existing farm for use in a modern, high volume, ACID-compliant, OLTP website, which serves hundreds of DML transactions per second.
The default values of which two key variables do you change to ensure seamless operation of the database?
(Choose two.)
The default values of which two key variables do you change to ensure seamless operation of the database?
(Choose two.)
Question 97
These details are shown when logged in to an account:

Which set of statements would match the accounts shown?
mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';

Which set of statements would match the accounts shown?
mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';
Question 98
What are three methods to reduce MySQL server exposure to remote connections? (Choose three.)
Question 99
You are asked to examine user accounts and find:

Which two statements will best secure this environment? (Choose two.)

Which two statements will best secure this environment? (Choose two.)
Question 100
The following grants were executed:
GRANT CREATE ROUTING ON sales.* TO 'webadmin'@'%';
GRANT ALTER ON PROCEDURE sales.myproc TO 'webadmin'@'%';
A user successfully connects to the database as webadminand created a stored procedure named get_reports.The next day, the user logs in again as webadminand wants to delete the stored procedure named get_reports,and therefore, issues the following statement:
USE sales;
DROP PROCEDURE IF EXISTS get_reports;
What is the result of executing the statement?
GRANT CREATE ROUTING ON sales.* TO 'webadmin'@'%';
GRANT ALTER ON PROCEDURE sales.myproc TO 'webadmin'@'%';
A user successfully connects to the database as webadminand created a stored procedure named get_reports.The next day, the user logs in again as webadminand wants to delete the stored procedure named get_reports,and therefore, issues the following statement:
USE sales;
DROP PROCEDURE IF EXISTS get_reports;
What is the result of executing the statement?
