1z1-908 Exam Question 21

Binary log events for the ‘mydb1’ schema must be copied to a different schema name ‘mydb2’.
Which command will do this?
  • 1z1-908 Exam Question 22

    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?
  • 1z1-908 Exam Question 23

    Examine this command, which executes successfully:
    $ mysqlrouter --bootstrap user@hostname:port --directory=directory_path Which activity is performed?
  • 1z1-908 Exam Question 24

    There are five MySQL instances configured with a working group replication.
    Examine the output of the group members:

    Which two statements are true about network partitioning in the cluster? (Choose two.)
  • 1z1-908 Exam Question 25

    Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)