MySQL 8.0 Database Administrator — Question 91

Which two statements are true about MySQL Enterprise Backup? (Choose two.)

Answer options

• A. It supports backing up only table structures.
• B. It can perform hot or warm backups.
• C. It creates logical backups.
• D. It supports the creation of incremental backups.
• E. It supports backup of a remote MySQL system.
• F. It supports restoring to a remote MySQL system.

Correct answer: D, F

Explanation

The correct answers are D and F because MySQL Enterprise Backup does indeed support the creation of incremental backups and allows for restoring to a remote MySQL system. Options A, C, and E are incorrect as they do not accurately describe the capabilities of MySQL Enterprise Backup, and option B, while true, is not one of the selected correct answers.