Oracle 1Z0-908 Exam - Topic 9 Question 34 Discussion

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

Question #: 34
Topic #: 9

[All 1Z0-908 Questions]

There are five MySQL instances configured with a working group replication.

Examine the output of the group members:

Which two statements are true about network partitioning in the cluster? (Choose two.)

AThe cluster will shut down to preserve data consistency.

BThe cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.

CThe group replication will buffer the transactions on the online nodes until the unreachable nodes return online.

DThere could be both a 2 node and 3 node group replication still running, so shutting down group replication and diagnosing the issue is recommended.

EA manual intervention to force group members to be only the working two instances is required.

Show Suggested Answer

Suggested Answer: A, B

by Franklyn at May 10, 2022, 01:49 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-908 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Val

5 months ago

I've seen option D happen before, it's a real issue in some setups.

upvoted 0 times

...

Solange

5 months ago

Option A is a myth; the cluster won't shut down automatically.

upvoted 0 times

...

Kara

5 months ago

Wait, so the cluster can just keep buffering? That's surprising!

upvoted 0 times

...

Ernie

5 months ago

I disagree, I believe option C is more accurate.

upvoted 0 times

...

Gregoria

5 months ago

I think option B is definitely true.

upvoted 0 times

...

Nilsa

5 months ago

I recall that manual intervention might be necessary, but I can't remember if it was for option E or something else related to node management.

upvoted 0 times

...

Lizbeth

5 months ago

I’m a bit confused about whether the transactions get buffered or if they just get lost during a partition.

upvoted 0 times

...

Latanya

6 months ago

I think option B sounds familiar because we discussed high availability and the ip_whitelist in our practice sessions.

upvoted 0 times

...

Andra

6 months ago

I remember something about how the cluster handles network partitions, but I'm not sure if it automatically shuts down or not.

upvoted 0 times

...

Nelida

6 months ago

Definitely C - scalability. You need to make sure the network infrastructure can handle the higher bandwidth and real-time data requirements of VoIP before rolling it out.

upvoted 0 times

...

Lilli

6 months ago

Hmm, I'm a little unsure about this one. I know auditing is important for security, but I'm not sure exactly how it would prevent misuse in this case.

upvoted 0 times

...