What three are correct statements about MySQL backups? (Choose three.)

Question

Options

• AThey are used to set up the initial binary log files.
• BThey are used to prevent data corruption.
• CThey are used to set up a replication slave.
• DThey are used to recover data.
• EThey are used to set up a test system.

• A
  4% (1)
• B
  92% (23)
• D
  4% (1)

Explanation

MySQL backups serve three key legitimate purposes covered here: preventing data corruption impact by allowing restoration of uncorrupted data (B), initializing a replication slave by restoring a consistent snapshot of the master onto the slave server before replication begins (C), and spinning up a test/dev environment that mirrors production without affecting live data (E).

Why A is wrong: Binary log files are configured via my.cnf/my.ini server settings (log_bin directive), not initialized through backups - that's a server configuration task, not a restore operation.

Why D is wrong (tricky!): While backups are associated with recovery, in MySQL's exam framing "recovering data" is treated as the mechanism backups enable, not a standalone use case purpose - the listed purposes focus on what you do with backups proactively, not reactively. (Note: some exam versions list D as correct instead of B - worth double-checking your specific course materials.)

Memory tip: Think "ACE the backup use cases" - but swap A for B: Blockade corruption, Clone a slave, Environment testing. If you see "set up binary logs" or "recover data" as options, those are the classic distractors targeting conflation of backup outcomes with backup purposes.

No community discussion yet for this question.