Question 81

You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory.
Why is it important to remove snapshots after completing a raw backup in this way?
  • Question 82

    You are investigating the performance of a query which selects data from an InnoDB table.
    Consider this Performance Schema diagnostics output for the query:

    Which statement is true about the output?
  • Question 83

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

    You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this?
  • Question 85

    Consider:

    Which statement best describes the meaning of the value for the key_len column?