Examice

Exam 1z0-908 All QuestionsBrowse all questions from this exam

Question 115

You issue this command:

SHOW SLAVE STATUS -

In the output, there is a value for Seconds_behind_master.

How is this time calculated?

It is the time between the I/O thread receiving details of the master's last transaction and the time it was applied by the SQL thread.

It is the time between the most recent transaction written to the relay logs and the time it was committed on the master.

It is the time between the I/O thread receiving details of the master’s last transaction and the time it was written to the relay log on the slave.

It is the time between the most recent transaction applied by a SQL thread and the time it was committed on the master.

Correct Answer: D

The time value for Seconds_behind_master indicates the delay between the most recent transaction applied by a SQL thread on the slave and the time it was committed on the master. It essentially measures how

Discussion

marklvOption: D

Not A, not the last transaction of the master. It deals with the current sql being applied. "difference between the current timestamp on the replica and the original timestamp logged on the source for the event currently being processed on the replica." So D. Time of slave and time it was run on the master, for the query just finished on the slave.

DhanushkaOption: A

This field is an indication of how “late” the replica is: When the replica is actively processing updates, this field shows the difference between the current timestamp on the replica and the original timestamp logged on the source for the event currently being processed on the replica. When no event is currently being processed on the replica, this value is 0.