MySQL 8.0 Database Administrator (1z0-908) Practice Test

Questions # 41:

Which two statements are true about using backups of the binary log? (Choose two.)

Options:

Multiple binary logs can be used to restore data.

Multiple binary logs can be applied in parallel for faster data restoration.

Binary logs are relatively small, and therefore, excellent for long-term storage and disaster recovery.

Binary logs can always be used to unapply unwanted schema changes.

They allow for point-in-time recovery of the data.

Questions # 42:

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:

Question # 42

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?

Options:

RESET MASTER;

SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

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;

RESET SLAVE;

SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;

SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa—aaaaaaaaaaaa:1-10300;

RESET MASTER;

SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;

SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

RESET SLAVE;

SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;

Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Pass the Oracle MySQL Database Administration 1z0-908 Questions and answers with ExamsMirror

Exam 1z0-908 Premium Access

Options:

Options:

TOP CODES