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?

• A.Backup State = Compressed BackupOperation = copy-back
• B.Backup State = Raw BackupOperation = apply-log
• C.Backup State = Raw BackupOperation = backupdir-to-image
• D.Backup State = Prepared BackupOperation = validate
• E.Backup State = Prepared BackupOperation = apply-log

Comment: *

Name: *

Email: *

Verification: *

An admin attempts to enforce stronger security by using these commands:

The admin then leaves the system running with the specified changes. What are two remaining security concerns?

• A.validate_password_policy cannot be set without restarting the MySQL instance.
• B.validate_password_dictionary_file cannot be set without restarting the MySQL instance.
• C.The validate_password plug-in has not been loaded.
• D.The name of the dictionary file is too obvious.
• E.The dictionary file word list is too short.
• F.The dictionary file is an insecure location.

Comment: *

Name: *

Email: *

Verification: *

A MySQL replication slave is set up as follows:
* Uses all InnoDB tables
* Receives ROW-based binary logs
* Has the read-only option
The replication slave has been found in an error state.
You check the MySQL error log file and find these entries:

What are two possible causes for this error to occur? (Choose two.)

• A.The slave was created with mysqldump -u root -p --skip-lock-tables -all-databases > /data/data.sql
• B.The applications have the SUPER privilege, which allows them to update rows.
• C.For tables with UNIQUE keys, statement-based replication must be used to maintain integrity.
• D.The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.
• E.The slave user does not have INSERT, UPDATE, or DELETE permission and cannot execute the Write_rows function.

Comment: *

Name: *

Email: *

Verification: *

A MySQL Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain this additional configuration:

The MySQL Server is restarted without error.
What effect will the new configuration have on existing account?

• A.They are not affected by this configuration change.
• B.They will have their passwords updated on start-up to sha256_password format.
• C.They all connect via the secure sha256_password algorithm without any configuration change.
• D.They will have to change their password the next time they login to the server.

Comment: *

Name: *

Email: *

Verification: *

You have a config file for a running DB with this excerpt:
[mysqld]
tmp_table_size=16M
sort_buffer_size=256k
To address a query performance problem of connecting to the DB from an application on another host, you log in and make these changes to the DB:
mysql> SET GLOBAL tmp_table_size=32000000;
mysql> SET sort_buffer_size=2000000;
This solves the problem with your queries. However, later the DB instance is restarted and the performance problem returns.
Which three best describe this scenario?

• A.The query benefited from sort_buffer_size increase.
• B.Session variables are not persistent across server restarts.
• C.Global variables are not persistent across server restarts.
• D.The query benefited from tmp_table_size increase.
• E.The query benefited from sort_buffer_size and tmp_table_size increases.
• F.sort_buffer_size should match tmp_table_size to be optimal.

Comment: *

Name: *

Email: *

Verification: *