New Year Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

Oracle MySQL 8.0 Database Administrator 1z0-908 Question # 12 Topic 2 Discussion

Oracle MySQL 8.0 Database Administrator 1z0-908 Question # 12 Topic 2 Discussion

1z0-908 Exam Topic 2 Question 12 Discussion:
Question #: 12
Topic #: 2

Examine the modified output:

1z0-908 Question 12

Seconds_Behind_ Master value is steadily growing. What are two possible causes? (Choose two.)


A.

The master is most probably too busy to transmit data and the slave needs to wait for more data.


B.

One or more large tables do not have primary keys.


C.

This value shows only I/O latency and is not indicative of the size of the transaction queue.


D.

The master is producing a large volume of events in parallel but the slave is processing them serially.


E.

The parallel slave threads are experiencing lock contention.


Get Premium 1z0-908 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.