Question 26

The account [email protected] has been created with privileges, as shown in the output:

The account [email protected] exists.
The account [email protected] does not exist.
Which three statements will succeed when executed by [email protected]? (Choose three.)
  • Question 27

    You are remotely logged in to MySQL as the user "backup".
    The account has temporarily been granted full privileges WITH GRANTto perform the actions required.
    You want to change the password for the locally existing "backup" user.
    Select the three commands which will perform the required action. (Choose three.)
  • Question 28

    There are multiple instances of MySQL Server running on a single OS that is backed up using the mysqlbackup command.
    The /etc/my/cnf contains default values, for example, datadir=/var/lib/mysql/, with extra instances having their own separate my.cnf file (for example /etc/mysql/instanceN.cnf) overriding the defaults. A restore of the second instance is attempted from the mysqlbackup archive using this command:
    mysqlbackup --backup-dir=/opt/backup/mysql/instance2 copy-back
    Upon starting the second MySQL instance, you notice that the data does not match the expected backup.
    Which command-line option is required to successfully update the second instance?
  • Question 29

    You have just executed a manual backup by using this command:
    mysqlbackup -u root -p --socket=/tmp/my.sock --backup-dir=/my/backup/ backup The operation completed without error.
    What is the state of this backup and operation required before it is ready to be restored?
  • Question 30

    Which three options are most likely to be changed for production form their default values?