MySQL 8.0 Database Administrator — Question 96

Examine this command, which executes successfully on InnoDB Cluster: dba.dropMetadataSchema()
Which two statements are true? (Choose two.)

Answer options

• A. Group Replication will be dissolved and all metadata purged.
• B. Group Replication is still operational, but InnoDB Cluster must be reimported under MySQL Shell.
• C. The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.
• D. The command drops the mysql_innodb_cluster_metadata schema and re-creates it.
• E. The mysql_innodb_cluster_metadata schema is dropped from all reachable members of the cluster.
• F. Connections driven by MySQL Router are not affected by the command.

Correct answer: C, E

Explanation

The correct answer is C because the command specifically drops the metadata schema from the instance where it was executed. E is also correct as the command affects all reachable cluster members. Options A, B, D, and F are incorrect as they do not accurately describe the outcome of the command.