An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest datA.
The SHOW SLAVE STATUS indicates these values:
* RELAY_LOG_FILE=hostname-relay-bin.00004
* RELAY_LOG_POS=1383
Which command set would make the slave current?

• A.STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;
• B.STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = 'hostname-relay-bin.00004', RELAY_LOG_POS = 1383;
• C.STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE
  'hostname-relay-bin.00004', RELAY_LOG_POS = 1383;
• D.STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;

Comment: *

Name: *

Email: *

Verification: *

You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-typeis set to DATABASE.

Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output? (Choose two.)

• A.The slave cannot process the relay log fast enough to use all threads.
• B.THREAD_ID 21has stopped running.
• C.The slave is configured with slave_parallel_workers= 4
• D.The salve has two intermediate relay slaves connected to it.
• E.The server needs more cores to use all slave threads.
• F.At most, two schemas are being updates concurrently.

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *

You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysql system database are missing. Which step do you perform to create the contents of the data directory?

• A.Run the create_system_tables.sql file
• B.Invoke mysqld with the --initialize option.
• C.Run the mysql_unpack.sql file
• D.Invoke mysql with the --initialize option.

Comment: *

Name: *

Email: *

Verification: *

The Performance Schema includes these tables related to status variables:

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

• A.The variable values in global_statusare the sum of those in status_by_threadgrouped by the variable name.
• B.All these tables have the same number of rows.
• 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.

Comment: *

Name: *

Email: *

Verification: *