MySQL 8.0 Database Administrator — Question 55

You are considering using file-system snapshots to back up MySQL.
Which three statements are true? (Choose three.)

Answer options

• A. They take roughly twice as long as logical backups.
• B. They allow direct copying of table rows with operating system copy commands.
• C. They work best for transaction storage engines that can perform their own recovery when restored.
• D. The backup window is almost zero from the perspective of the application.
• E. They do not back up views, stored procedures, or configuration files.
• F. There is a slight performance cost while the snapshot is active.
• G. They do not use additional disk space.

Correct answer: C, E, G

Explanation

Statement C is correct because file-system snapshots are particularly suited for transaction storage engines that can manage their own recovery processes. Statement E is also true as snapshots do not capture views or stored procedures, which are essential to the database's structure. Lastly, statement G is accurate since snapshots are designed to be efficient and do not occupy additional disk space. The other options either exaggerate time requirements or misrepresent the nature of snapshots.