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

Carmen

4 days 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

...

Ruby

5 days 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

...

Pearly

11 days 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

14 days 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

15 days 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

16 days 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

17 days 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

21 days ago

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

upvoted 0 times

...

Rosalyn

22 days ago

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

upvoted 0 times

...