QUESTION 73
You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-typeis set to DATABASE.

Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output? (Choose two.)

QUESTION 74
You are asked to examine user accounts and find:

Which two statements will best secure this environment? (Choose two.)

QUESTION 75
You back up by using mysqldump.
Which configuration is required on the MySQL Server to allow point-in-time recovery?

QUESTION 76
You want to create the first configuration file for a new installation of MySQL.
– You will start mysqldmanually (not automate it to start when the host machine starts or execute as a service).
– You will stop mysqldusing mysqladmin.
– You will interact with mysqldby using only the command-line client mysql.
Which option identifies a maximal set of sections where you can put the “max_allowed_packet=16M” parameter without creating a problem?

QUESTION 77
You have successfully provisioned the latest MySQL 5.7 database instance on a physical host, to be added to an existing farm for use in a modern, high volume, ACID-compliant, OLTP website, which serves hundreds of DML transactions per second.
The default values of which two key variables do you change to ensure seamless operation of the database? (Choose two.)

QUESTION 78
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?

QUESTION 79
Consider the key buffer in a MySQL server. Which two statements are true about this feature? (Choose two.)

QUESTION 80
You have forgotten the root user account password. You decide to reset the password and execute:

Which additional argument makes this operation safer?

QUESTION 81
A crucial database, ‘db_prod’, just disappeared from your production MySQL instance.
In reviewing the available MySQL logs (General, Audit, or Slow) and your own application-level logs, you identified this command from a customer facing application:
SELECT id FROM users WHERE login=’payback!’;DROP DATABASE db_prod;’
Which three methods could have been used to prevent this SQL injection attack from happening?

QUESTION 82
You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files? (Choose two.)

QUESTION 83
The MySQL error log shows:
InnoDB: Warning: a long semaphore wait:
The relevant parts of the InnoDB monitor output shows:

Which two options would help avoid the long wait in the future?

QUESTION 84
Which MySQL utility copies the master instance to a slave instance on the same host?

QUESTION 85
Which statement best describes the purpose of the InnoDB buffer pool?

QUESTION 86
Host slave1 has ip address 192.0.2.10.
Host slave2 has ip address 203.0.113.50
Examine these commands:

Why did this error occur?

QUESTION 87
You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory.
Why is it important to remove snapshots after completing a raw backup in this way?

QUESTION 88

What does the possible_keyscolumn in this output denote?

QUESTION 89
You are using replication and the binary log files on your master server consume a lot of disk space.
Which two steps should you perform to safely remove some of the older binary log files? (Choose two.)

QUESTION 90
Where does MySQL Linux RPM install the mysqld binary?

QUESTION 91
You have a MySQL instance with the following variables in the /etc/my.cnf file:

You issue these statements:
USE prices;
UPDATE sales.january SET amount=amount+1000;
An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.
Which statement is true? (Choose two.)

QUESTION 92
The MySQL error log shows:
InnoDB: Warning: a long semaphore wait:
The relevant parts of the InnoDB monitor output shows:

Which two options would help avoid the long wait in the future?

QUESTION 93
An employee cannot access the company database. You check the connection variables:

A look at the user privileges shows:

What is a valid explanation for why one of the users is unable to connect to the database?

QUESTION 94
You have a server that has very limited memory but has a very large table.
You will use mysqldump to back up this table.
Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?

QUESTION 95
Force Majeure is a catastrophic failure on a major level of the database operation. Regular backups are key to helping avoid data loss in such situations.
Which two other steps can help avoid data loss in a major catastrophe?

QUESTION 96
A master-slave replication setup has the slave showing this error:

On the master server, the binary logs show:

What could explain this error? (Choose two.)