Exam 1z0-908 topic 1 question 74 discussion

Actual exam question from Oracle's 1z0-908

Question #: 74
Topic #: 1

An attempt to recover an InnoDB Cluster fails.
Examine this set of messages and responses:
host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage()
Reconfiguring the default cluster from complete outage…
The instance ‘host1:3377'’ was part of the cluster configuration.
Would you like to rejoin it to the cluster? [y/N]: y
The instance ‘host2:3377’ was part of the cluster configuration.
Would you like to rejoin it to the cluster? [y/N]: y
Dba.rebootClusterFromCompleteOutage: The active session instance isn’t the most updated in comparison with the ONLINE instances of the Cluster’s metadata. Please use the most up to date instance: ‘host1:3377’. (RuntimeError)
Which statement is true?

A. The instance deployed on host3 must be rebuilt with a backup from the primary instance.
B. The cluster is running and there is at least one ONLINE instance.
C. The instance deployed on host3 must be synchronized from a donor deployed on host1 by using the command cluster.addInstance(‘host1:3377’).
D. It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET(set1,set2).
E. The active session instance is invalid and must be re-created by using the command shell.connect(‘host3:3377’).

Show Suggested Answer

Suggested Answer: C 🗳️

by marklv at Oct. 22, 2023, 1:50 a.m.

Comments

Submit Cancel

marklv

9 months, 2 weeks ago

B, the error message mentions an online server

upvoted 2 times

marklv

7 months, 4 weeks ago

None of the servers were up before command was executed, So B is not it. The only right might be the last one with GTID_SUBSET

upvoted 1 times

...

Exam 1z0-908 All Questions

View all questions & answers for the 1z0-908 exam

Exam 1z0-908 topic 1 question 74 discussion

Comments

marklv

marklv

SY0-701