Question 41

You back up by using mysqldump.
Which configuration is required on the MySQL Server to allow point-in-time recovery?
  • Question 42

    A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUS output:

    You execute a 'SHOW CREATE TABLE mytable" on the slave:

    The table mytable on the slave contains:

    You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?
  • Question 43

    What is the best method for monitoring Group Replication conflict resolution?
  • Question 44

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

    An admin attempts to enforce stronger security by using these commands:

    The admin then leaves the system running with the specified changes. What are two remaining security concerns?