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.)
  • 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';
  • 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.)
  • 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?