1Z0-908 practice question 24 of 25
Which two statements are true about raw binary backups? (Choose two.)
Full set: 140 questionsA 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.
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.
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.
Keep practicing
Take the free 1Z0-908 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-908 practice questions
- Question 2You must run multiple instances of MySQL Server on a single host. Which three methods are…
- Question 3Which two tools are available to monitor the global status of InnoDB locking? (Choose two…
- Question 4Which two MySQL Server accounts are locked by default? (Choose two.)
- Question 5All MySQL Server instances belonging to InnoDB Cluster have SSL configured and enabled. Y…
- Question 6t is a non-empty InnoDB table. Examine these statements, which are executed in one sessio…
- Question 8Examine this command, which executes successfully: $ mysqlrouter --bootstrap user@hostnam…
