You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this?

• A.log-master-updates
• B.rpl-recovery-rank
• C.server-id
• D.enable-master-start
• E.log_bin
• F.master-logging

Comment: *

Name: *

Email: *

Verification: *

These details are shown when logged in to an account:

Which set of statements would match the accounts shown?

• A.mysql> CREATE USER 'robert'@'localhost' IDENTIFIED BY 'secret_password';mysql>CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';
• B.mysql> CREATE_USER ''@'' IDENTIFIED WITH authentication_pam ACCOUNT LOCK;mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';mysql> GRANT PROXY ON 'employee'@'localhost' TO ''@'';
• C.mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';mysql> GRANT PROXY ON 'employee'@'localhost' TO 'robert'@'localhost';
• D.mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';mysql> CREATE USER ''@'' IDENTIFIED BY 'valid_password' WITH PROXY 'employee'@'localhost';

Comment: *

Name: *

Email: *

Verification: *

A MySQL replication slave is set up as follows:
Uses all InnoDB tables

Receives ROW-based binary logs

Has the read-only option

The replication slave has been found in an error state.
You check the MySQL error log file and find these entries:

What are two possible causes for this error to occur?

• A.The slave user does not have INSERT, UPDATE, or DELETEpermission and cannot execute the Write_rowsfunction.
• B.For tables with UNIQUE keys, statement-based replication must be used to maintain integrity.
• C.The applications have the SUPERprivilege, which allows them to update rows.
• D.The slave was created with mysqldump -u root -p --skip-lock-tables -all-databases
  > /data/data.sql
• E.The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.

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 status_by_account are the sum of those in status_by_host and status_by_user grouped by the variable name.
• B.The global_status table is equivalent to the SHOW GLOBAL STATUS statement.
• C.The session_status table is equivalent to status_by_thread for the current thread.
• D.All these tables have the same number of rows.
• E.The variable values in global_status are the sum of those in status_by_thread grouped by the variable name.

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 mysql with the --initialize option.
• C.Invoke mysqld with the --initialize option.
• D.Run the mysql_unpack.sql file

Comment: *

Name: *

Email: *

Verification: *