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

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

    Correct Answer: B, D

    The commands 'cluster.setPrimaryInstance()' and 'cluster.forceQuorumUsingPartitionOf()' are not part of the initial InnoDB Cluster creation process. 'cluster.setPrimaryInstance()' is used to manually designate a primary instance in the cluster, typically used after the cluster has already been created. 'cluster.forceQuorumUsingPartitionOf()' is used to manage quorum in the case of partitioning issues, which also occurs post-creation. Hence, they are excluded from the InnoDB Cluster creation procedure.

Discussion
dmeesOptions: AB

A. dba.configureInstance() B. cluster.setPrimaryInstance() These commands are not used during the creation of an InnoDB Cluster. The dba.configureInstance() command is used to configure an instance for InnoDB Cluster after it has been added to the cluster. The cluster.setPrimaryInstance() command is used to manually set a specific instance as the primary instance in the cluster.

marklvOptions: DG

D. not used in creation. Used if there is an issue later. G. not used because if there are no errors, you can check it after its been created.