QUESTION: 1
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 Backup Operation = copy-back
B. Backup State = Raw Backup Operation = apply-log
C. Backup State = Prepared Backup Operation = validate
D. Backup State = Prepared Backup Operation = apply-log
E. Backup State = Raw Backup Operation = backupdir-to-image

Answer(s): E
QUESTION: 2
Which MySQL utility program should you use to process and sort the Slow Query Log based on
query time or average query time?

A. mysqldumpslow
B. mysqldump
C. mysqlaccess
D. mysqlshow
E. mysqlslow

Answer(s): A

QUESTION: 3
Consider:
Which statement best describes the meaning of the value for the key_len column?
https://Xcerts.com
2