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

Comment: *

Name: *

Email: *

Verification: *

Which command enables rule-based MySQL Auditing capabilities?

• A.shell> mysql < audit_log_filter_linux_install.sql
• B.shell> mysqld --initialize --log-raw=audit.log
• C.mysql> INSTALL PLUGIN audit_log;
• D.mysql> INSTALL COMPONENT audit_log;

Comment: *

Name: *

Email: *

Verification: *

You execute this command:
shell> mysqlpump --exclude-databases=% --users
Which statement is true?

• A.It creates a logical backup of all MySQL user accounts.
• B.It creates a logical backup of all metadata, but contains no table data.
• C.It returns an error because the mysqldump command should have been used.
• D.It creates a logical backup of only the users database.

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.innodb_buffer_pool_size
• D.table_open_cache
• E.sort_buffer_size
• F.tmp_table_size

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about MySQL Enterprise Backup? (Choose two.)

• A.It supports backing up only table structures.
• B.It supports restoring to a remote MySQL system.
• C.It supports the creation of incremental backups.
• D.It supports backup of a remote MySQL system.
• E.It can perform hot or warm backups.
• F.It creates logical backups.

Comment: *

Name: *

Email: *

Verification: *