Free 200-125 Dumps Sample Question 9

By using the asynchronous MySQL Replication architecture, data can be repBy using the asynchronous MySQL Replication architecture, data can be replicated to slaves. Identify three use cases of MySQL Replication.

Option:

A. MySQL Replication Connector/J (ReplicationDriver) is provided to allow read capability on slave and write capability on master.
B. MySQL Enterprise Backup will back up from Slave automatically.
C. It provides multi-master access where the application can write and read data across the database servers.
D. It allows backup to be done on the slave without impacting the master.
E. You can create a slave server for reporting applications, which get only read access to the slave servers. It off-loads the master server. Additional servers allow different database server configuration.

Answer: B,D,E