MySQL 8.0 Database Administrator — Question 82

Which two are use cases of MySQL asynchronous replication? (Choose two.)

Answer options

• A. You can scale writes by creating a replicated mesh.
• B. It guarantees near real-time replication between a master and a slave.
• C. You can scale reads by adding multiple slaves.
• D. MySQL Enterprise Backup will automatically back up from an available slave.
• E. It allows backup to be done on the slave without impacting the master.

Correct answer: C, E

Explanation

The correct answers, C and E, highlight the ability to scale read operations by adding multiple slaves and the benefit of performing backups on the slave without impacting the master. Option A is incorrect because replicated meshes do not specifically relate to scaling writes in this context, while option B is incorrect as it describes synchronous replication rather than asynchronous.