MySQL 8.0 Database Administrator — Question 40

Which two statements are true about raw binary backups? (Choose two.)

Answer options

• A. They are converted to a highly compressible binary format.
• B. The data format is identical to how MySQL stores the data on disk.
• C. They are required to obtain FIPS security compliance.
• D. The resulting files are easily human readable.
• E. They are faster than logical backups because the process is a simple file or file system copy.

Correct answer: B, D

Explanation

Option B is correct because raw binary backups maintain the same data format as MySQL uses on disk, making restoration straightforward. Option D is incorrect; raw binary files are not easily human-readable compared to logical backups which are formatted for easier understanding. Options A, C, and E are also incorrect as they misrepresent the characteristics and requirements of raw binary backups.