Examice

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

Go to Exam

Question 97

Examine these InnoDB Cluster parameter settings:

Now examine the partial status:

A permanent network failure isolates host3.

Which two statements are true? (Choose two.)

The instance deployed on host2 is elected as the new primary instance.

The instance deployed on host3 is expelled from the cluster and must be rejoined using cluster.addInstance ('host3:3377')

The instance deployed on host3 will automatically rejoin the cluster when connectivity is re-established.

Failure of the instance deployed on host1 provokes an outage.

The issuing command cluster.switchToMuitiPrimaryMode() will fail to enable multi-primary mode.

The primary instance can be specified by using the command cluster.setPrimaryInstance(:).

Correct Answer: B, D

When host3 is isolated due to a permanent network failure, it will be expelled from the cluster because the 'exitStateAction' is set to 'ABORT_SERVER'. Therefore, host3 will need to be rejoined using a command like 'cluster.addInstance('host3:3377')'. This makes option B correct. The instance on host1 has the same member weight as host3. In the event of a failure of host1, since host3 is already isolated and host2 has a lower member weight, this would likely provoke an outage due to the imbalance in member weights. This makes option D correct.

Discussion

marklvOptions: BF

"A" my not be true. It will most likely be. B, host 3 is kicked out F, setprimaryinstance will work

DhanushkaOptions: AB

Lowest weigh pick first ,