1z1-908 Exam Question 16
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.)
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.)
1z1-908 Exam Question 17
Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?
1z1-908 Exam Question 18
Examine these commands and output:

Which connection ID is holding the metadata lock?

Which connection ID is holding the metadata lock?
1z1-908 Exam Question 19
You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)
Which three methods are supported? (Choose three.)
1z1-908 Exam Question 20
Examine this statement and output:

You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)

You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)