Which two storage engines provide a view of the data consistent with the storage system at any moment? (Choose two.) A. MyISAM B. NDB C. MEMORY D. ARCHIVE E. InnoDB

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.) A. Use SET GLOBAL binlog_expire_logs_seconds=<value> and restart…

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? A. You use the MyISAM storage engine for most common tables. B.…

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 data. Examine your backup requirement: The MySQL system being backed up can never be…

A MySQL server is monitored using MySQL Enterprise Monitor’s agentless installation. Which three features are available with this installation method? (Choose three.) A. MySQL Replication monitoring B. network-related information and network characteristics C. MySQL Query Analysis data D. CPU utilization…

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…

Examine this command and output: Which two options will improve the security of the MySQL instance? (Choose two.) A. Remove group read/write privileges from the private_key.pem file. B. Remove world read privileges from the server-cert.pem certificate file. C. Change the…

Examine this command, which executes successfully: cluster.addInstance(‘<user>@<host>:<port>’, {recoveryMethod: ‘clone’}) Which three statements are true? (Choose three.) A. The account used to perform this recovery needs the BACKUP_ADMIN privilege. B. A target instance must exist, then it will be provisioned with…

Which three settings control global buffers shared by all threads on a MySQL server? (Choose three.) A. sort_buffer_size B. key_buffer_size C. table_open_cache D. read_buffer_size E. innodb_buffer_pool_size F. tmp_table_size

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. Replication will fail because…