1Z0-908 practice question 14 of 25
Which two statements are true about using backups of the binary log? (Choose two.)
Full set: 140 questionsThe 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.
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.
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).
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…
