1Z0-888 Question #59: Real Exam Question with Answer & Explanation

Question

mysql> SHOW SLAVE STATUS\G
*************************** 1. row ***************************
 Slave_IO_state: Waiting for master to send event
 ...
 Slave_IO_Running: Yes
 Slave_SQL_Running: Yes
 ...
 SQL_Delay: 360
 SQL_Remaining_Delay: NULL
Slave_SQL_running_state: Slave has read all relay log; waiting for the slave I/O
 thread to update it

Options

• AThe master has performed a large transaction, which will take 360 seconds to complete on the slave.
• BThe network latency between the master and the slave is 360 milliseconds.
• CThe slave will need an estimated 360 seconds to update the remaining contents from the relay log.
• DThe slave was configured for delayed replication with a delay of six minutes.