Which three options are most likely to be changed for production form their default values? (Choose three.)

A. innodb_buffer_pool_size

B. max_connections

C. join_buffer_size

D. character_set_system

E. innodb_log_file_size

F. max_user_connections

G. port

You back up by using mysqldump.

Which configuration is required on the MySQL Server to allow point-in-time recovery?

A. binlog_format=STATEMENT

B. log-bin

C. apply-log

D. bonlog_format=ROW

E. gtid_enable

You created a backup of the world database with this command: shell> mysqldump --opt world > dump.sql

Which two will import the data from dump.sql? (Choose two.)

A. shell> mysqladmin recover test dump.sql

B. shell> mysql test < dump.sql

C. shell> mysqlimport test dump.sql

D. mysql> USE test; mysql> LOAD DATA INFILE `dump.sql';

E. mysql>USE test; mysql>SOURCE dump.sql;

There are multiple instances of MySQL Server running on a single OS that is backed up using the

mysqlbackup command.

The /etc/my/cnf contains default values, for example, datadir=/var/lib/mysql/, with extra instances having

their own separate my.cnf file (for example /etc/mysql/instanceN.cnf) overriding the defaults.

A restore of the second instance is attempted from the mysqlbackup archive using this command:

mysqlbackup --backup-dir=/opt/backup/mysql/instance2 copy-back

Upon starting the second MySQL instance, you notice that the data does not match the expected backup.

Which command-line option is required to successfully update the second instance?

A. --restore=2

B. --copy-back-from-log

C. --backup-instance=/var/lib/mysql/instance2

D. --instance=/var/lib/mysql/instance2

E. --defaults-file=/etc/mysql/instance2.cnf

You attempt to connect to a MySQL Server by using the mysql client program. However, you receive this notice:

What would you run to fix the issue?

A. the mysql_upgrade script

B. the mysql client with the --ignore-password-hashing option

C. the mysql_secure_installation script to update server security settings

D. the mysql client with the --enable-cleartext-plugin option

E. the install plugin command for the mysql_cleartext_password plugin

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

A. mysqlfailover

B. mysqldbcopy

C. mysqlrplsync

D. mysqlserverclone

Consider:

Which statement best describes the meaning of the values in the ref columns?

A. world.City.CountryCode is used as the primary key for the Country table.

B. No indexed columns are used to select rows from the City table. The world.City.CountryCode column is used to select rows in the Country table.

C. world.City.CountryCode is used to sort the rows in the City table.

D. No indexed columns are used to select rows from the Country table. The world.City.CountryCode column is used to select rows in the City table.

What three are correct statements about MySQL backups? (Choose three.)

A. They are used to set up the initial binary log files.

B. They are used to prevent data corruption.

C. They are used to prevent data theft.

D. They are used to set up a replication slave.

E. They are used to recover data.

F. They are used to set up a test system.

The MySQL instance is a default RPM installation on a Linux server. Where are the errors written?

A. in the /var/lib/mysql/hostname.log file

B. no logging enabled by default

C. in the /var/log/mysqld.err file

D. in the syslog daemon on the server

You have a MySQL instance running in a single cpu (1vCPU) VM in a shared infrastructure environment.

Your users are complaining that MySQL is sporadically slow and you have a suspicion that the VM infrastructure host is at fault due to resource contention.

You review the output of your scripts that monitor the database VM operating system during an extended period of slowdown.

What are the two most common indicators of the VM infrastructure host being at fault due to resource contention? (Choose two.)

A. 10% CPU

B. 90% RAM

C. 9.1 five minute load average, 10% iowait

D. 100% CPU use, 50% RAM

E. 100% iowait

F. 100% SWAP, 100% RAM