1Z0-908 Exam Question 1

You are backing up raw InnoDB files by using mysqlbackup.
Which two groups of files will be backed up during a full backup? (Choose two.)
  • 1Z0-908 Exam Question 2

    An existing asynchronous replication setup is running MySQL 8.
    Which two steps are a part of implementing GTID replication? (Choose two.)
  • 1Z0-908 Exam Question 3

    You have configured GTID-based asynchronous replication with one master and one slave.
    A user accidentally updated some data on the slave.
    To fix this, you stopped replication and successfully reverted the accidental changes.
    Examine the current GTID information:

    You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover.
    Which set of actions would allow the slave to continue replicating without erroneous transactions?
    RESET MASTER;
  • 1Z0-908 Exam Question 4

    Examine these commands and output:

    Which connection ID is holding the metadata lock?
  • 1Z0-908 Exam Question 5

    You execute this command:
    shell> mysqlpump --exclude-databases=% --users
    Which statement is true?