Exam 1z0-908 topic 1 question 52 discussion

A is wrong. Replica pulls from master.

B. They contain events that describe database changes on the master. Binary logs in MySQL contain events that describe changes to the data in the master database. These changes can include INSERTs, UPDATEs, DELETEs, and other data modifications. E. They are pulled from the master to the slave. In asynchronous replication, the slave server typically pulls the binary logs from the master server. The slave connects to the master and requests the binary log events it needs to replicate changes from the master. Option A is not entirely accurate because binary logs are not "pushed" from the master to the slave; instead, they are made available on the master for the slave to pull. Option C and D are incorrect because binary logs do not necessarily contain all queries or administrative commands run on the master; they specifically contain events related to database changes, not all SQL queries or administrative commands.

Each replica that connects to the source requests a copy of the binary log. That is, it pulls the data from the source, rather than the source pushing the data to the replica. The replica also executes the events from the binary log that it receives.