For accessing a new default MySQL Cloud Service (CS) cloud environment, you used the "Create SSH Keys function" during the guided MySQL CS setup. You want to use Putty from your Windows Client. Identify the correct steps. A. You open…

Consider the following SQL statement which is using the InnoDB storage engine and with global AUTOCOMMIT=1. BEGIN; CREATE TABLE t1 (c1 INT); CREATE TABLE t2 (c1 INT); ROLLBACK; What is the result after issuing the ROLLBACK command? A. Both the…

You have a user on your MySQL instance who is flooding the server with complex queries and large INSERTS, which prevents another user with a higher priority from running queries. Which two choices will limit the number of SELECTS to…

When creating a FOREIGN KEY constraint, what SQL variable must be specified? A. UNIQUE PRIMARY KEY values for both child and parent tables B. a REFERENCE in the child table to the parent table C. the SET_FOREIGN_KEY variable in the…

Select three privileges that are necessary to successfully back up a server instance with the mysqlbackup command after the initial installation. A. CREATE TEMPORARY TABLES B. REPLICATION CLIENT C. GRAND OPTION D. RELOAD E. INDEX

Which three features are available only on MySQL Enterprise Workbench? A. GUI for MySQL Enterprise Backup B. MySQL Audit Log Inspector C. Database Design D. Database Migration inclusive Support E. Visual Performance Dashboard

MySQL Enterprise provides query analyzing metrics for SQL statements. Which four MySQL environments will provide QUAN metrics? A. All MySQL (when MySQL connectors with Aggregator is used for the application) B. MySQL 5.5.9 (and later) C. MySQL 5.7.9 Community (and…

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. Network-related information and network characteristics B. Security-related advisors warning (for example, password…

Identify the MySQL plug-in that is provided only with MySQL Enterprise Edition and servers to increase performance and high availability. A. the MySQL memcached plug-in B. the MySQL PAM Authentication plug-in C. the MySQL Thread Pool plug-in D. the MySQL…

The user ‘OS-user’@’localhost’ was created to monitor connections and shut down the server, and was granted the following privileges: GRANT PROCESS, SHUTDOWN ON *.* to ‘OS-user’@’localhost’; Identify three commands that the OS-user can execute. A. SHOW STATUS; B. SHUTDOWN; C.…