Oracle Exam 1Z0-908 Topic 4 Question 83 Discussion

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

Question #: 83
Topic #: 4

[All 1Z0-908 Questions]

You have an InnoDB Cluster configured with three servers.

Examine this command, which executes successfully:

mysqldump -uroot -p -d mydatabase > mydatabase_backup.sql

Due to data loss, the cluster is initialized and a restore is attempted resulting in this error:

ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin running

Which two actions, either one of which, can fix this error and allow a successful restore of the cluster? (Choose two.)

AStop all instances except the primary read/write master instance and run the restore.

BRemove the @@GLOBAL.gtid_purged statement from the dump file.

CCreate the backup by using the --set-gtid-purged=OFF option.

DRemove the group replication plugin from each instance before restoring.

ERemove the @@GLOBAL.gtid_executed statement from the dump file.

FRestore using the --set-gtid-purged=OFF option.

Show Suggested Answer

Suggested Answer: D, E

by Rolland at Jul 09, 2024, 07:50 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Melissa

2 months ago

Haha, I love how the options are like a choose-your-own-adventure book. 'Remove this, remove that, turn to page 42 for the winning answer!' I'm going with C) and F) just to spice things up.

upvoted 0 times

Tiara

16 days ago

Good choices! Let's see if that fixes the error and allows the successful restore.

upvoted 0 times

...

Arlette

18 days ago

F) Restore using the --set-gtid-purged=OFF option.

upvoted 0 times

...

Emiko

21 days ago

C) Create the backup by using the --set-gtid-purged=OFF option.

upvoted 0 times

...

Carmen

2 months ago

Wait, did they seriously ask us to choose two answers? That's just cruel. I'm going with B) and F) - can't be too careful with those GTID statements!

upvoted 0 times

Glenn

11 days ago

F) Restore using the --set-gtid-purged=OFF option.

upvoted 0 times

...

Donette

1 months ago

B) Remove the @@GLOBAL.gtid_purged statement from the dump file.

upvoted 0 times

...

Ruby

2 months ago

Ugh, Group Replication issues are the worst. I'd go with D) and remove the plugin before restoring. That way, you don't have to worry about that GTID_PURGED problem.

upvoted 0 times

Minna

19 days ago

Yeah, I think removing the plugin is the way to go. Let's try that first.

upvoted 0 times

...

Malika

25 days ago

That could work too, but I think removing the plugin altogether might be a safer bet.

upvoted 0 times

...

Cyndy

1 months ago

But what if we just remove the @@GLOBAL.gtid_purged statement from the dump file instead? Would that work?

upvoted 0 times

...

Kris

2 months ago

I agree, Group Replication problems are a headache. Removing the plugin sounds like a good solution.

upvoted 0 times

...

Pearly

2 months ago

Hmm, this seems like a tricky one. I'm thinking B) or F) might do the trick, but I'm not 100% sure. Removing that GTID_PURGED statement could be the key to a successful restore.

upvoted 0 times

...

Leota

2 months ago

I'm not sure about option B. I think option C could also work by creating the backup with the --set-gtid-purged=OFF option.

upvoted 0 times

...

Tonette

2 months ago

I agree with Marguerita. Option B seems like the most logical solution to allow a successful restore of the cluster.

upvoted 0 times

...

Marguerita

2 months ago

I think option B is the right choice because removing the @@GLOBAL.gtid_purged statement from the dump file should fix the error.

upvoted 0 times

...

Gabriele

2 months ago

I'm not sure about option B. Maybe we should also consider option F, restoring with the --set-gtid-purged=OFF option.

upvoted 0 times

...

Linn

2 months ago

I agree with Rosalyn. Option B seems like the right choice to allow a successful restore of the cluster.

upvoted 0 times

...

Rosalyn

2 months ago

I think option B could fix the error because it involves removing the @@GLOBAL.gtid_purged statement.

upvoted 0 times

...