MySQL 8.0 Database Administrator — Question 26

Which two are true about binary logs used in asynchronous replication? (Choose two.)

Answer options

• A. They are pushed from the master to the slave.
• B. They contain events that describe database changes on the master.
• C. They contain events that describe all queries run on the master.
• D. They contain events that describe only administrative commands run on the master.
• E. They are pulled from the master to the slave.

Correct answer: B, E

Explanation

The correct answers are B and E. Option B is correct because binary logs do indeed contain events that represent changes made to the database on the master. Option E is also correct as the slave pulls the binary logs from the master. Options A, C, and D are incorrect because binary logs are not pushed (A), they do not capture all queries (C), and they do not solely record administrative commands (D).