clapgeek logo
To satisfy a security requirement, you have created or altered some user accounts to include REQUIRE X509.
Which additional task needs to be performed for those user accounts to fulfill the requirement to use X509?
A MySQL Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain this additional configuration:
The MySQL Server is restarted without error.
What effect will the new configuration have on existing account?
Examine the mysqldumpslow output:
Which two options could explain the slow query? (Choose two.)
Consider the index information for the dept_emp table in the employee’s schema:
Which two conclusions can be made based on the output of the query? (Choose two.)
Consider:
Which statement best describes the meaning of the value for the key_len column?
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.)
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:
Which four steps must be included in the backup strategy? (Choose four.)
One of your colleagues is trying to make a change using the mysql command-line client for his or her application session.
The colleague instant messages you this command:
mysql> SET SESSION max_connections = 200;
Why does the command fail?
Which storage option for MySQL data directory typically offers the worst performance in a highly concurrent, OLTP-heavy, IO-bound workload?
You have a consistent InnoDB backup created with mysqldump, the largest table is 50 GB in size.
You start to restore your backup with this command;
shell> mysql –u root –p < backup.sql
After 30 minutes, you notice that the rate of restore seems to have slowed down. No other processes or external factors are affecting server performance.
Which is the most likely explanation for this slowdown?
You back up by using mysqldump.
Which configuration is required on the MySQL Server to allow point-in-time recovery?
Consider the join_buffer_size parameter in MySQL Server.
Which two statements are true about the join buffer? (Choose two.)
TESTED 16 Jun 2025