Which two storage engines provide a view of the data consistent with the storage system at any
moment? (Choose two.)
AC
Reference:
https://zetcode.com/mysql/storageengines/
Your MySQL installation is running low on space due to binary logs. You need to reduce your log
space usage urgently.
Which two sets of actions when completed will accomplish this? (Choose two.)
AD
Reference:
https://severalnines.com/database-blog/my-mysql-database-out-disk-space
A colleague complains about slow response time on your website.
Examine this query and output:
What is the most likely cause for the high number of lock waits?
B
Reference:
https://severalnines.com/database-blog/how-fix-lock-wait-timeout-exceeded-error-
mysql
You have a MySQL system with 500 GB of data that needs frequent backups.
You use a mix of MyISAM and InnoDB storage engines for your dat
a. Examine your backup requirement:
The MySQL system being backed up can never be unavailable or locked to the client applications.
The recovery from the backup must work on any system.
Only 1 hour of data can be lost on recovery of the backup.
Which option fulfills all backup requirements?
C
A MySQL server is monitored using MySQL Enterprise Monitors agentless installation.
Which three features are available with this installation method? (Choose three.)
CEG
You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)
A. The mysqlcheck --check --all-databases command takes table write locks while performing a series
of checks.
B. The mysqlcheck --optimize --all-databases command reclaims free space from table files.
C. The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.
D. The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.
E. The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual
table corruptions.
DE
(none)
Explanation
Examine this command and output:
Which two options will improve the security of the MySQL instance? (Choose two.)
CE
Examine this command, which executes successfully:
cluster.addInstance(<user>@<host>:<port>, {recoveryMethod: clone})
Which three statements are true? (Choose three.)
ADF
Which three settings control global buffers shared by all threads on a MySQL server? (Choose three.)
ABF
Reference:
https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/server-system-variables.html
You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTER command are correct. Examine the GTID information
from both master and slave:
Which statement is true?
A
Reference:
https://bugs.mysql.com/bug.php?id=86643