1Z0-908 practice question 14 of 25

Which two statements are true about using backups of the binary log? (Choose two.)

Full set: 140 questions
Answer options
A: Multiple binary logs can be used to restore data. Correct answer
B: Multiple binary logs can be applied in parallel for faster data restoration.
C: Binary logs are relatively small, and therefore, excellent for long-term storage and disaster recovery.
D: Binary logs can always be used to unapply unwanted schema changes.
E: They allow for point-in-time recovery of the data. Correct answer
Correct Answer:
A. Multiple binary logs can be used to restore data.; E. They allow for point-in-time recovery of the data.
Explanation

The binary log is a set of files containing information about data modifications made to a MySQL server instance. Its primary use in recovery is to enable point-in-time recovery (PITR). This process involves restoring a full backup taken at an earlier time and then applying the events from the binary logs created since that backup. This re-applies all data changes sequentially, bringing the database to a specific, desired moment. Because binary logs are rolled over into new files based on size or time, a recovery operation will frequently require applying multiple, sequential binary log files to reach the target recovery point.

Why Incorrect

B: Binary logs must be applied sequentially in the order they were created to ensure data consistency and transactional integrity. Parallel application would corrupt the data state. C: On a busy server, binary logs can grow very large and numerous, making them unsuitable for long-term storage compared to compressed full backups. D: The binary log does not provide a native "unapply" or "undo" function. To reverse a change, one must perform a point-in-time recovery to a state before the change occurred.

References

1. Oracle, MySQL 8.0 Reference Manual, Section 7.5, "Point-in-Time (Incremental) Recovery": This section explicitly states, "To perform a point-in-time recovery... you need to restore a full backup... and then replay the binary log files that were written after the backup was made." This confirms both point-in-time recovery (E) and the use of multiple log files (A).

2. Oracle, MySQL 8.0 Reference Manual, Section 7.5.1, "Point-in-Time Recovery Using Event Positions": The examples provided in this section demonstrate the application of a range of binary logs for recovery, such as: mysqlbinlog binlog.000001 binlog.000002 | mysql -u root -p. This command shows two binary log files being used sequentially for a single recovery operation, validating option A.

3. Oracle, MySQL 8.0 Reference Manual, Section 5.4.4, "The Binary Log": This section describes the purpose of the binary log, stating it is used for "certain data recovery operations. After a backup has been restored, the events in the binary log that were recorded after the backup was made can be re-executed to bring databases up to date." This directly supports the concept of point-in-time recovery (E).

Scroll to Top