Oracle Exam 1Z0-908 Topic 4 Question 87 Discussion

Actual exam question for Oracle's 1Z0-908 exam

Question #: 87
Topic #: 4

Examine these InnoDB Cluster parameter settings:

Now examine the partial status:

A permanent network failure isolates host3.

Which two statements are true? (Choose two.)

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

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

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

DFailure of the instance deployed on host1 provokes an outage.

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

FThe primary instance can be specified by using the command cluster.setPrimaryInstance(<host>:).

Show Suggested Answer

Suggested Answer: D, E

by Tammara at Sep 13, 2024, 03:26 AM

Limited Time Offer

25%

10 days ago

I'm going with A and D. The instance on host2 will be elected as the new primary, and if host1 fails, that will cause an outage since it's the current primary.

upvoted 0 times

...

I think the answer is B and C. The instance on host3 is isolated, so it needs to be rejoined using the addInstance command. And since it's isolated, it should automatically rejoin when connectivity is restored.

upvoted 0 times

...

Rodolfo

17 days ago

I'm not sure about option B. Do you think the instance on host3 needs to be manually rejoined?

upvoted 0 times

...

Alline

22 days ago

I agree with you, Lenna. Option C is also true because the instance on host3 will rejoin when connectivity is restored.

upvoted 0 times

...

Lenna

26 days ago

I think option A is true because the instance on host2 becomes the new primary.

upvoted 0 times

...

Oracle Exam 1Z0-908 Topic 4 Question 87 Discussion

Contribute your Thoughts:

Carma

Jimmie

Jannette

Adell

Ruthann

Effie

Rodolfo

Alline

Lenna