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.)

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.)
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?
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?
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?