Question 106

You are using the Performance Schema to investigate replication on a slave which has a single master.
The option slave-parallel-typeis set to DATABASE.

Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output? (Choose two.)
  • Question 107

    Which two statements are true about InnoDB auto-increment locking? (Choose two.)
  • Question 108

    Group Replication uses global transaction identifiers to track executed transactions and are fundamental in avoiding transaction conflict. Which additional three steps help in avoiding conflicts in group replication?
    (Choose three.)
  • Question 109

    You created a backup of the world database with this command:
    shell> mysqldump --opt world > dump.sql
    Which two will import the data from dump.sql?
  • Question 110

    A particular government's security policy is to have very strict data encryption and safety settings. This is done by restricting access based on their own CA authority and limiting access to particular users within a department. Which method could be used to restrict access as required?