Oracle MySQL 5.7 Database Administrator — Question 4

Which three are key advantages of standard MySQL replication? (Choose three.)

Answer options

• A. supports native automatic failover
• B. enables automatic resync of databases when discrepancies are detected
• C. provides arbitrary geographic redundancy with minimal overhead to master
• D. synchronously guarantees identical slave copy
• E. is easy to configure and has low performance overhead
• F. can easily add slaves for read scaling

Correct answer: B, E, F

Explanation

The correct answers, B, E, and F, highlight essential features of MySQL replication, such as its capability for automatic database resynchronization, ease of setup, and the ability to easily scale reads by adding slaves. Options A, C, and D are incorrect because they do not represent key advantages of standard MySQL replication; for instance, automatic failover is not natively supported and synchronous guarantees are not a characteristic of MySQL replication.