Exam 1z0-908 topic 1 question 3 discussion

Actual exam question from Oracle's 1z0-908

Question #: 3
Topic #: 1

You have configured GTID-based asynchronous replication with one master and one slave.
A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes.
Examine the current GTID information:

You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover.
Which set of actions would allow the slave to continue replicating without erroneous transactions?

A. RESET MASTER;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
B. SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
C. RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa—aaaaaaaaaaaa:1-10300;
D. RESET MASTER;
SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
E. RESET SLAVE;
SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

Show Suggested Answer

Suggested Answer: D 🗳️

by marklv at Sept. 29, 2023, 6:16 a.m.

Comments

Submit Cancel

trabalho

2 weeks, 4 days ago

Selected Answer: C

"If I have already undone the changes made on the SLAVE, I only need to adjust the GTID instead of deleting all binary logs with RESET MASTER. Wouldn't it be more correct to reset the state on the SLAVE and set the GTID to 3820 on the SLAVE? Option C."

upvoted 1 times

...

marklv

3 months, 2 weeks ago

d is right

upvoted 1 times

...

Exam 1z0-908 All Questions

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

Exam 1z0-908 topic 1 question 3 discussion

Comments

trabalho

marklv

SY0-701