Examice

Exam 1z0-908 All QuestionsBrowse all questions from this exam

Go to Exam

Question 132

Examine this command, which executes successfully on InnoDB Cluster: dba.dropMetadataSchema()

Which two statements are true? (Choose two.)

Group Replication will be dissolved and all metadata purged.

Group Replication is still operational, but InnoDB Cluster must be reimported under MySQL Shell.

The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.

The command drops the mysql_innodb_cluster_metadata schema and re-creates it.

The mysql_innodb_cluster_metadata schema is dropped from all reachable members of the cluster.

Connections driven by MySQL Router are not affected by the command.

Correct Answer: C, E

The command dba.dropMetadataSchema() is used within an InnoDB Cluster to drop the metadata schema associated with the cluster. Specifically, the mysql_innodb_cluster_metadata schema is removed from the instance where the connection is established and from all reachable members of the cluster. This operation does not dissolve the Group Replication or recreate the metadata schema, but it does remove the metadata, effectively requiring the InnoDB Cluster to be reimported if it is to be used again.

Discussion

marklvOptions: AE

A and E, I think, it destroys the cluster