A.It returns an error because the mysqldump command should have been used.

B.It creates a logical backup of only the users database.

C.It creates a logical backup of all MySQL user accounts.

D.It creates a logical backup of all metadata, but contains no table data.

A.On the slave, alter the MySQL master connection setting with:
CHANGE MASTER TO MASTER_AUTO_POSITION = 1;

B.Execute this on the slave to enable GTID:
START SLAVE IO_THREAD WITH GTID;

C.Restart MySQL (master and slave) with these options enabled:
--gtid_mode=ON
--log-bin
--log-slave-updates
--enforce-gtid-consistency

D.Enable GTID by executing this on the master and the slave:
SET GLOBAL GTID_ENABLED=on;

E.On the slave, alter the MySQL master connection setting with:
ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1;

F.Execute this on the slave to enable GTID:
RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC;

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

B.The user failed to define a username and the connecting username defaulted to ‘’@’%’.

C.The user is authorized as the rsmith@localhostuser.

D.The user is authenticated as the anonymous proxy user ‘’@’%’.

E.The user is authorized as the accounting@localhostuser.

A.Multiple binary logs can be used to restore data.

B.They allow for point-in-time recovery of the data.

C.Binary logs can always be used to unapply unwanted schema changes.

D.Multiple binary logs can be applied in parallel for faster data restoration.

E.Binary logs are relatively small, and therefore, excellent for long-term storage and disaster recovery.

A.It defines all innodb tablespace options relative to a starting parent directory.

B.It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.

C.It is not necessary because innodb_data_home_dir is already defined.

D.It adds more temporary workspace in addition to the innodb_tmpdir location.

E.It allows scanning of other locations to discover more innodb tablespaces.