Examine this command, which executes successfully:

Which statement is true?

A. Only files for MySQL or Its built-in storage engines are backed

B. Only non-encrypted files are backed up.

C. The backup includes only data files and their metadata.

D. Only InnoDB data and log files are backed up.

E. Only tables stored in their own tablespaces are backed up.

Examine these statements and output:

Which statement is true?

A. The user is logged in with --user=accounting as an option.

B. The user is authenticated as the anonymous proxy user `'@'%'.

C. The user is authorized as the accounting@localhost user.

D. The user is authorized as the rsmith@localhost user.

E. The user failed to define a username and the connecting username defaulted to `'@'%'.

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. Stop all instances except the primary read/write master instance and run the restore.

B. Remove the @@GLOBAL.gtid_purged statement from the dump file.

C. Create the backup by using the --set-gtid-purged=OFF option.

D. Remove the group replication plugin from each instance before restoring.

E. Remove the @@GLOBAL.gtid_executed statement from the dump file.

F. Restore using the --set-gtid-purged=OFF option.

Which two statements are true about using MySQL Enterprise Monitor Query Analyzer? (Choose two.)

A. The single query QRTi pie chart in the Query Analyzer view is based on the average execution of all statements.

B. It is possible to retrieve a normalized statement, but never the exact statement that was executed.

C. It is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.

D. It is possible to list and analyze statements in an arbitrary graph range selection from timeseries graphs.

E. It is possible to import data into the Query Analyzer from heterogeneous sources, such as CSV.

Which three sets of item information are visible in the mysql system database? (Choose three.)

A. help topics

B. performance monitoring information

C. plugins

D. information about table structures

E. audit log events

F. rollback segments

G. time zone information and definitions