You attempt to connect to a MySQL Server by using the mysqlclient program. However, you receive this notice:

What would you run to fix the issue?

A MySQL database uses all InnoDB tables and is configured as follows;

You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.
Which two arguments will you pass to mysqldump to achieve this?

Which two methods will provide the total number of partitions on a table? (Choose two.)

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? (Choose two.)

Consider:

Which statement best describes the meaning of the values in the ref columns?