MySQL 8.0 Database Administrator — Question 71

Which two are characteristics of snapshot-based backups? (Choose two.)

Answer options

• A. Snapshot-based backups greatly reduce time during which the database and applications are unavailable.
• B. There is no need for InnoDB tables to perform its own recovery when restoring from the snapshot backup.
• C. The frozen file system can be cloned to another virtual machine immediately into active service.
• D. A separate physical copy must be made before releasing the snapshot backup.
• E. Snapshot backups can be used only in virtual machines.

Correct answer: D, E

Explanation

Option D is correct because a separate physical copy is necessary to ensure data integrity before using the snapshot. Option E is also correct as snapshot backups are designed specifically for virtual machine environments. The other options either incorrectly describe the functionality of snapshot backups or do not align with their characteristics.