Question: 1
You will configure a MySQL Server to act as a replication master. Which two options must be configured
correctly to allow this?
Question: 2
Which three options are most likely to be changed for production form their default values?
Question: 3
A MySQL replication slave is set up as follows:
Uses all InnoDB tables
Receives ROW-based binary logs
Has the read-only option
The replication slave has been found in an error state.
You check the MySQL error log file and find these entries:
What are two possible causes for this error to occur?
Question: 4
You are no longer able to log in to an existing MySQL Server because the root password credentials not
working. You need to reset the root password to complete various administrative tasks. What are the two major methods that will achieve this?
Question: 5
An admin attempts to enforce stronger security by using these commands:
The admin then leaves the system running with the specified changes. What are two remaining security
concerns?