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 webadmin and created a stored procedure named get_reports. The next day, the user logs in again as webadmin and 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?

• A. The user will get an error because he or she does not have the permission to drop stored procedures.
• B. The stored procedure named get_reports will be dropped.
• C. The user will get an error because he or she did not put the database name in front of the stored procedure name.
• D. The user will get an error because he or she did not use the ALTER statement to drop the stored procedure.

You have a MySQL instance running in a single cpu (1vCPU) VM in a shared infrastructure environment.
Your users are complaining that MySQL is sporadically slow and you have a suspicion that the VM infrastructure host is at fault due to resource contention.
You review the output of your scripts that monitor the database VM operating system during an extended period of slowdown.
What are the two most common indicators of the VM infrastructure host being at fault due to resource contention? (Choose two.)

• A. 100% SWAP, 100% RAM
• B. 100% CPU use, 50% RAM
• C. 90% RAM
• D. 100% iowait
• E. 9.1 five minute load average, 10% iowait
• F. 10% CPU

Which two methods will provide the total number of partitions on a table? (Choose two.)

• A. Query the INFORMATION_SCHEMA.PARTITIONS table
• B. Use the command: SHOW TABLE STATUS
• C. Query the INFORMATION_SCHEMA.TABLES table for the partition_count
• D. Query the performance_schema.objects_summary_global_by_type table
• E. Use the command: SHOW CREATE TABLE

An administrator installs MySQL to run under a mysql OS account. The administrator decides to disable logins to the mysql account by using /nologin or /bin/false as the user's shell setting.
Which statement is true?

• A. The mysql user needs a login and its home directory must be the base directory of the installation.
• B. The OS needs to allow logging in as mysql so that administrative tasks can be performed.
• C. This prevents mysqld from starting when standard startup scripts are used.
• D. This prevents creation of a command shell with the mysql account, while allowing mysqld to run.