After analysis on the slow query log on a high-end OLTP service, the table identified in the slow queries is:

What are the two most likely reasons for the slowness given this output? (Choose two.)

You are receiving complaints from your application administrators that they are seeing periodic stalls in database response (no queries to any table are returning results for several seconds or longer). You monitor your system and notice that the durations of those stalls correspond to peaks in disk I/O.
Which 2 things should you investigate?

You have just created a replication slave from a backup of the master made with mysqldump:

You try to log in to the slave with the application user, but fail as follows:

The login works on the master.
Which two changes to the process can fix the issue?

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.)

You are creating a strategy for backing up MySQL using a cold binary backup. The MySQL instance is a replication master with global transaction identifiers (GTIDs) enabled and it uses Transparent Data Encryption (TDE). Other than the configuration required to make the instance a replication master and enabled GTIDs and TDE, the instance is using all default settings.
The requirements for the backup are:
* It must be possible to rebuild the instance using the backup.
* It must be verified.
* It must allow for a catastrophic hardware failure.
Which four steps must be included in the backup strategy? (Choose four.)