MySQL 8.0 Database Administrator — Question 69

Which two statements are true about using backups of the binary log? (Choose two.)

Answer options

• A. Multiple binary logs can be used to restore data.
• B. Multiple binary logs can be applied in parallel for faster data restoration.
• C. Binary logs are relatively small, and therefore, excellent for long-term storage and disaster recovery.
• D. Binary logs can always be used to unapply unwanted schema changes.
• E. They allow for point-in-time recovery of the data.

Correct answer: D, E

Explanation

Options D and E are correct because binary logs indeed allow for reverting unwanted schema changes and enable point-in-time recovery of data. Options A and B are incorrect as they do not accurately represent the functionality of binary logs, while option C is misleading since binary logs can grow large and may not be suitable for long-term storage.