Exam 1z0-908 All QuestionsBrowse all questions from this exam
Question 45

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

    Correct Answer: A, E

    Multiple binary logs can be used to restore data, as they contain a record of all changes made to the database over time. This sequential information allows for reconstruction of the database up to a certain point. Binary logs also enable point-in-time recovery because they allow for replaying of transactions to the moment just before an unwanted event or failure occurred.

Discussion
FelipeKOptions: AE

Binary logs can be used to restore data to a specific point in time. This is known as point-in-time recovery. Multiple binary logs can be used to restore data, as they contain a record of all changes made to the database

FelipeK

A- Multiple binary logs can be used to restore data. Binary logs record all changes to the database, and multiple logs can be used in sequence to restore the database to a particular point in time1. E- They allow for point-in-time recovery of the data. Binary logs can be used to perform point-in-time recovery, which involves replaying changes from the logs to the database up to a specific point in time1