1Z1-888 Exam Question 116

You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this?
  • 1Z1-888 Exam Question 117

    What two statements are true regarding FLUSH TABLES FOR EXPORT? (Choose two.)
  • 1Z1-888 Exam Question 118

    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?
    STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;
  • 1Z1-888 Exam Question 119

    Consider the two partial outputs of the SHOW GLOBAL VARIABLES command from a master and slave server:
    Master:

    Slave:

    There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?
  • 1Z1-888 Exam Question 120

    Which two are considered good security practices when using passwords? (Choose two.)