Examine the modified output:

Seconds_Behind_ Master value is steadily growing. What are two possible causes? (Choose two.)

• A.This value shows only I/O latency and is not indicative of the size of the transaction queue.
• B.One or more large tables do not have primary keys.
• C.The master is most probably too busy to transmit data and the slave needs to wait for more data.
• D.The master is producing a large volume of events in parallel but the slave is processing them serially.
• E.The parallel slave threads are experiencing lock contention.

Comment: *

Name: *

Email: *

Verification: *

Examine this command, which executes successfull
mysqlbackup --defaults-file=/backups/server-my.cnf --backup-dir=/backups/full copy-back Which statement is true about the copy-back process?

• A.The copy-back process is used to overwrite a new backup over an existing backup.
• B.It restores files from the backup directory to their original MySQL server locations.
• C.It restores files from the data directory to their original MySQL server locations.
• D.The copy-back process makes inconsistent backups.

Comment: *

Name: *

Email: *

Verification: *

A user wants to connect without entering his or her username and password on the Linux command prompt.
Which three locations can be used to store the user's mysql credentials to satisfy this requirement? (Choose three.)

• A.$HOME/.mysqlrc file
• B.$HOME/.mysql/auth/login file
• C./etc/my.cnf file
• D.$MYSQL_HOME/my.cnf file
• E.$HOME/.mylogin.cnf file
• F.$HOME/.my.cnf file
• G.DATADIR/mysqld-auto.cnf file

Comment: *

Name: *

Email: *

Verification: *

Which three settings control global buffers shared by all threads on a MySQL server? (Choose three.)

• A.read_buffer_size
• B.key_buffer_size
• C.tmp_table_size
• D.innodb_buffer_pool_size
• E.sort_buffer_size
• F.table_open_cache

Comment: *

Name: *

Email: *

Verification: *

You have an InnoDB Cluster configured with three servers.
Examine this command, which executes successfully:
mysqldump -uroot -p -d mydatabase > mydatabase_backup.sql
Due to data loss, the cluster is initialized and a restore is attempted resulting in this error:
ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin running Which two actions, either one of which, can fix this error and allow a successful restore of the cluster? (Choose two.)

• A.Remove the @@GLOBAL.gtid_executed statement from the dump file.
• B.Remove the @@GLOBAL.gtid_purged statement from the dump file.
• C.Restore using the --set-gtid-purged=OFF option.
• D.Remove the group replication plugin from each instance before restoring.
• E.Stop all instances except the primary read/write master instance and run the restore.
• F.Create the backup by using the --set-gtid-purged=OFF option.

Comment: *

Name: *

Email: *

Verification: *