Question 41
You back up by using mysqldump.
Which configuration is required on the MySQL Server to allow point-in-time recovery?
Which configuration is required on the MySQL Server to allow point-in-time recovery?
Question 42
A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUS output:

You execute a 'SHOW CREATE TABLE mytable" on the slave:

The table mytable on the slave contains:

You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?

You execute a 'SHOW CREATE TABLE mytable" on the slave:

The table mytable on the slave contains:

You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used?
Question 43
What is the best method for monitoring Group Replication conflict resolution?
Question 44
Which two are considered good security practices when using passwords? (Choose two.)
Question 45
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?

The admin then leaves the system running with the specified changes. What are two remaining security concerns?