1z0-908 MySQL 8.0 Database Administrator

Loading demo links...

Showing 7–9 of 10 questions

Question 7

Examine this output:

Which change should optimize the number of buffer pool instances for this workload?

Select an option, then click Submit answer.

  • Increase the number of buffer pool instances to 16.

  • Increase the number of buffer pool instances to 32.

  • Decrease the number of buffer pool instances to 1.

  • Increase the number of buffer pool instances to 12.

  • Decrease the number of buffer pool instances to 4.

Question 8

What does the binlog dump thread do?

Select an option, then click Submit answer.

  • It monitors and schedules the rotation/deletion of the binary logs.

  • It reads the relay log and executes the events contained in them.

  • It acquires a lock on the binary log for reading each event to be sent to the slave.

  • It connects to the master and asks it to send updates recorded in its binary logs.

Question 9

Examine these commands and output:

Which connection ID is holding the metadata lock?

Select an option, then click Submit answer.

  • 20

  • 24

  • 21

  • 25

  • 22

  • 6