1Z1-888 Exam Question 121

Which three are key advantages of standard MySQL replication? (Choose three.)
  • 1Z1-888 Exam Question 122

    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.)
  • 1Z1-888 Exam Question 123

    The 'applicationdb' is using InnoDB and consuming a large amount of file system space. You have a /backup partition available on NFS where backups are stored.
    You investigate and gather this information:

    Three tables are stored in the InnoDB shared tablespace and the details are as follows:
    * The table data_currenthas 1,000,000 rows.
    * The table data_reports has 1,500,000 rows.
    * The table data_archivehas 4,500,000 rows.

    You attempt to free space from ibdata1by taking a mysqldump of the data_archivetable and storing it on your backup partition.

    Unfortunately, this action does not free any actual disk space back to the file system and the server disk space is running out.
    Which set of actions will allow you to free disk space back to the file system?
  • 1Z1-888 Exam Question 124

    You have installed the validate_password plug-in and set the validate_password_policy variable.
    Which validation is affected by the validate_password_policy setting?
  • 1Z1-888 Exam Question 125

    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?