MySQL 8.0 Database Administrator — Question 120

Examine this MySQL Shell command:
dba.rebootClusterFromCompleteOutage()
Which two statements are true? (Choose two.)

Answer options

• A. It reconfigures InnoDB Cluster if the cluster was stopped.
• B. It performs InnoDB Cluster instances rolling restart.
• C. It only starts all InnoDB Cluster instances.
• D. It is not mandatory that all instances are running and reachable before running the command.
• E. It stops and restarts all InnoDB Cluster instances and initializes the metadata.
• F. It only stops and restarts all InnoDB Cluster instances.
• G. It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.

Correct answer: B, D

Explanation

The correct answers are B and D. Option B is correct because the command performs a rolling restart of InnoDB Cluster instances, allowing for a smoother recovery. Option D is also true, as the command does not require all instances to be operational and reachable, which is essential for its functionality. The other options either misrepresent the command's capabilities or provide incorrect details about its operation.