Oracle MySQL 5.7 Database Administrator — Question 3

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?

Answer options

• 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

Correct answer: E

Explanation

The correct answer is E because the backup is in a 'Raw Backup' state, which indicates that it has not yet been processed for restoration. The required operation 'backupdir-to-image' is needed to prepare the backup for restoration. Options A, B, C, and D are incorrect because they either describe incorrect backup states or operations that do not apply to a raw backup.