A MySQL server was initialized with separate UNDO tablespaces. Users complain that when they roll back large transactions, the time to process the request takes too long. The DBA would like to move the MySQL InnoDB UNDO tablespace to a solid-state drive (SSD) for better performance. Is this possible and how?

• A. No. The UNDO tablespaces must remain on the same file system as the system tablespaces.
• B. Yes. Shut down, copy the UNDO tablespaces to the new location, and change the innodb_undo_directory value in your my.cnf.
• C. Yes. Shut down the mysqld process, enable the transportable_tablespace option, and move the UNDO directory to the SSD.
• D. No. The sequential write pattern of the UNDO tablespaces is not supported on modern SSD block devices.

You have created a new user with this statement:
CREATE USER `erika'@'localhost' IDENTIFIED BY `first#1Pass' PASSWORD EXPIRE; What is the outcome?

• A. You receive a syntax error that indicates that you cannot set a password and expire it at the same time.
• B. When `erika'@'localhost' tries to log in with the MySQL command-line client, the user will have to change the password before seeing the mysql> prompt.
• C. When `erika'@'localhost' tries to log in with the MySQL command-line client, the user will not be permitted to log in because the password is expired.
• D. When `erika'@'localhost' tries to log in with the MySQL command-line client, the user will be permitted to log in but will not be able to issue ant statements until the user changes the password.

You are setting up a new installation of MySQL Server 5.7 (a GA release.) You have used a ZIP or TAR package to ensure that the mysqld binary, along with its support files, such as plug-ins and error messages, now exist on the host. Assume that the default datadir exists on the host. You installed the binary in the default location (the default --basedir value) for your operating system. Which step should you perform before defining your own databases and database tables?

• A. Create a configuration file containing default-storage-engine=InnoDB.
• B. Create additional login accounts (so that everyone does not need to log in as root) and assign them appropriate privileges.
• C. Set an exception in the host machine's firewall to allow external users to talk to mysqld.
• D. Register mysqld as a service that will start automatically on this host machine.
• E. Execute a command with a minimal form of: mysql --initialize

What are three methods to reduce MySQL server exposure to remote connections? (Choose three.)

• A. setting specific grant privileges to limit remote authentication
• B. setting --mysql_secure_configuration to enable paranoid mode
• C. using SSL when transporting data over remote networks
• D. setting --skip-networking when remote connections are not required
• E. using the sql_mode=STRlCT_SECURE after connections are established for encrypted communications

The Performance Schema includes these tables related to status variables:

Which two facts are true about these tables? (Choose two.)

• A. All these tables have the same number of rows.
• B. The variable values in global_statusare the sum of those in status_by_threadgrouped by the variable name.
• C. The session_statustable is equivalent to status_by_threadfor the current thread.
• D. The variable values in status_by_accountare the sum of those in status_by_hostand status_by_user grouped by the variable name.
• E. The global_statustable is equivalent to the SHOW GLOBAL STATUSstatement.