Oracle MySQL 8.0 Database Administrator 1z0-908 Question # 3 Topic 1 Discussion

Oracle MySQL 8.0 Database Administrator 1z0-908 Question # 3 Topic 1 Discussion

1z0-908 Exam Topic 1 Question 3 Discussion:
Question #: 3
Topic #: 1

Your MySQL environment has asynchronous position based-replication with one master and one slave.

The slave instance had a disk I/O problem, so it was stopped.

You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.

You restart MySQL Server.

How can replication be restored?


A.

The slave relay logs should be deleted; then execute START SLAVE;


B.

The relay logs from the master should be used to replace the corrupted relay logs.


C.

The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;


D.

The slave needs to be restored from backup.


Get Premium 1z0-908 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.