1z0-888: MySQL 5.7 Database Administrator Slave Practice Questions

On a master server that is using statement-based replication, a table of log data has become very large. You decide to delete 100.000 rows. Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)

Select 2 answers.

• AA. Change the replication mode to mixed before issuing any delete statements when the limit clause is used.
• BB. If the data modification is non-deterministic, the query optimizer will resolve any potential issues.
• CC. Use the limit clause to limit the deletion to 100.000 rows.
• DD. Use the limit clause in conjunction with the order 3Y claus

Consider the two partial outputs of the SHOW GLOBAL VARIABLES command from a master and slave server: Master: Slave: There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?

• AA. The log_bin variable is set to OFF on the slave.
• BB. server_id is not unique.
• CC. The max_connections variable on the slave needs to be increased.
• DD. The shared_memory_base_name variable must match the master.
• EE. The version of the slave is newer that the version of the maste