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 STATUSindicates these values:
RELAY_LOG_FILE=hostname-relay-bin.00004

RELAY_LOG_POS=1383

Which command set would make the slave current?

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

Comment: *

Name: *

Email: *

Verification: *

You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.

What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running? (Choose two.)

• A.to prevent any transaction experiencing a deadlock
• B.to allow for point-in-time recovery on the slave
• C.to allow a backup to be created under reduced load
• D.to prevent schema changes from propagating to the slave before they are validated
• E.to allow the remaining events to be processed on the slave while not receiving new events from the master

Comment: *

Name: *

Email: *

Verification: *

An employee cannot access the company database. You check the connection variables:

A look at the user privileges shows:

What is a valid explanation for why one of the users is unable to connect to the database?

• A.Bob has max_user_connectionsset to zero, which blocks all his connections.
• B.Kay is already connected elsewhere and attempting to log in again.
• C.Joe has exceeded the max_user_connectionsglobal limit.
• D.All users are blocked because max_user_connectionsis accumulated over the host account information.
• E.connect_timeout is too small to allow a connection to occur.

Comment: *

Name: *

Email: *

Verification: *

A MySQL database uses all InnoDB tables and is configured as follows;

You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.
Which two arguments will you pass to mysqldump to achieve this? (Choose two.)

• A.--single-transaction
• B.--skip-opt
• C.--create-apply-log
• D.--lock-all-tables
• E.--master-data

Comment: *

Name: *

Email: *

Verification: *

Examine the mysqldumpslow output:

Which two options could explain the slow query?

• A.No index has been defined on the filtered column.
• B.A table lock is causing delays.
• C.A full table scan is being used.
• D.There are 108 queries still being executed.
• E.There is network congestion between client and server.

Comment: *

Name: *

Email: *

Verification: *