1Z1-888 Exam Question 131

What is the best method for monitoring Group Replication conflict resolution?
  • 1Z1-888 Exam Question 132

    The MySQL installation includes the mysql_config_editor utility for managing login paths stored in a .mylogin.cnf file.
    Which two are true about the login path feature? (Choose two.)
  • 1Z1-888 Exam Question 133

    You inherited a busy InnoDB OLTP Instance with 100 schemas and 100 active users per schema.
    Total dataset size is 200G with an average schema size of 2G.

    The data is transient and is not backed up and can be repopulated easily.

    Performance and responsiveness of the DB is paramount.

    The query pattern for the DB instance is split 90/10 read/write.

    DB host is dedicated server with 256G RAM and 64 cores.

    One of your colleagues made some recent changes to the system and users are now complaining of performance impacts.
    Which four configuration file edits might your colleague have performed to cause the negative DB performance? (Choose four.)
  • 1Z1-888 Exam Question 134

    Consider the table people with the definition:

    The application uses a query such as:
    SELECT * FROM people WHERE YEAR(Birthday) = 1980;
    The query is not using an index.
    Which two methods can be used to allow the query to use an index?
  • 1Z1-888 Exam Question 135

    Examine the mydata table and SELECT statements:

    You issue:
    mysql> begin;
    mysql> update mydata set a=0 where b=3;
    How many rows are now protected by locks with the default InnoDB configuration?