MySQL 8.0 Database Administrator — Question 100

Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)

Answer options

• A. dba.configureInstance()
• B. cluster.setPrimaryInstance()
• C. dba.configureLocalInstance()
• D. cluster.forceQuorumUsingPartitionOf()
• E. cluster.addInstance()
• F. dba.createCluster()
• G. dba.checkInstanceConfiguration()

Correct answer: B, D

Explanation

The correct answers, B and D, are not included in the InnoDB Cluster creation process. 'cluster.setPrimaryInstance()' is used after the cluster is created to set the primary instance, and 'cluster.forceQuorumUsingPartitionOf()' is used for quorum management, not for initial creation. The other options are all essential commands used during the cluster setup.