Which three statements are true about MySQL replication? (Choose three.)

Question

Options

• AReplication can use only TCP/IP connections.
• BAny instance can have multiple slaves, but it can have only one master.
• CEach instance in a replication topology must have a unique server ID.
• DBinary logs contain only transactions originating from a single MySQL instance.
• EEach slave must have its own MySQL user for replication.
• FBinary logging must be enabled on the master in order to replicate to other instances.
• GA replication user must have the SELECT privilege for all tables that need to be replicated.

• A
  8% (2)
• C
  81% (21)
• D
  4% (1)
• E
  8% (2)

Explanation

C is correct because MySQL requires every instance in a replication topology to have a unique server_id system variable - duplicate IDs cause conflicts and can break replication loops.

F is correct because replication works by slaves reading and replaying the master's binary log; if binary logging (log_bin) is not enabled on the master, there is simply no data for slaves to consume.

G is correct in the exam context because the replication account used to perform initial data snapshots (e.g., via mysqldump) or certain replication setups requires SELECT privilege on the replicated tables, in addition to REPLICATION SLAVE.

Why the distractors are wrong:

• A - False; MySQL also supports SSL/TLS overlays and on Windows can use named pipes or shared memory.
• B - False since MySQL 5.7+; multi-source replication allows a single slave to have multiple masters.
• D - False; with log_slave_updates enabled, binary logs on an intermediary server contain events that originated elsewhere in the chain.
• E - False; multiple slaves can share the same replication user account on the master.

Memory tip: Think "CaFé" - Config (unique server ID), File (binary log), Grant (privileges). These three are the prerequisites you set up before replication starts working.

No community discussion yet for this question.