1Z0-908 practice question 24 of 25

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

Full set: 140 questions
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. Correct answer
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
Correct Answer:
B. The data format is identical to how MySQL stores the data on disk.; E. They are faster than logical backups because the process is a simple file or file system copy.
Explanation

A raw binary backup, also known as a physical backup, involves directly copying the database files as they exist on the disk. This method is significantly faster than a logical backup because it bypasses the SQL layer and operates at the file system level, simply copying blocks of data. Consequently, the format of the backed-up data is identical to the internal format MySQL uses for storage. This direct copy approach is what gives physical backups their speed advantage over logical backups, which must process and convert data into SQL statements.

Why Incorrect

A. The format is not converted. A raw backup is a direct copy of the existing binary format. Compression may be applied, but this is a separate action, not a format conversion.
C. FIPS compliance pertains to the use of validated cryptographic modules for security functions within MySQL, not the format used for backups.
D. The resulting files are binary and not human-readable. Logical backups (e.g., from mysqldump) produce human-readable SQL statements.

References

1. MySQL 8.0 Reference Manual, Section 7.2, "Backup Methods": This section explicitly contrasts logical and physical backups. It states, "Physical backups consist of raw copies of the directories and files that store database contents. This type of backup is faster to perform than a logical backup because it involves only file copying without conversion." This supports options B and E.

2. MySQL 8.0 Reference Manual, Section 7.2.1, "Backup Policy": This section elaborates, "A physical backup, also called a 'raw' backup, copies the physical files that make up the database... Because this method is a straight file copy and does not involve any conversion, it is faster than a logical backup." This directly confirms that the process is a fast file copy (E) and that the data format is the same as the internal storage format (B).

3. MySQL 8.0 Reference Manual, Section 6.8, "FIPS Support": This section details the requirements for running MySQL in FIPS mode. The requirements focus on using a FIPS-certified OpenSSL library for cryptographic operations and do not mention any specific backup method or format, invalidating option C.

Scroll to Top