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

Examine this MySQL Shell command:

dba.rebootClusterFromCompleteOutage()

Which two statements are true? (Choose two.)

    Correct Answer: A, G

    The command dba.rebootClusterFromCompleteOutage() is used to recover an InnoDB Cluster after a complete outage where all members are down. It reconfigures InnoDB Cluster if the cluster was stopped, which is necessary to bring the cluster back to its operational state. Additionally, it picks the minimum number of instances necessary to rebuild the quorum and reconfigures the InnoDB Cluster, allowing the cluster to become operational even if not all instances are reachable.

Discussion
FelipeKOptions: AG

A. It reconfigures InnoDB Cluster if the cluster was stopped. This function is specifically designed to recover a cluster after a complete outage, which means that group replication has stopped on all member instances. G. It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster. The function retrieves the cluster metadata and topology from the current instance, checks which instances of the cluster are currently reachable, and recovers the cluster based on the metadata stored in that instance. If any member is currently unreachable, the function fails, but this check can be bypassed with the force option.

marklv

I don't know if it reconfigures anything.

marklvOptions: CD

C and D. It doesn't restart. Only a majority are needed to start the cluster. It just starts nodes.