Question 1

You are using the Performance Schema to investigate replication on a slave which has a single master.The option slave-parallel-type is set to DATABASE.Assume that all instruments and consumers are enabled and all threads are instrumented.Which two facts can be concluded from the given output? (Choose two.)

Options :

A : The salve has two intermediate relay slaves connected to it.

B : The slave is configured with slave_parallel_workers= 4.

C : At most, two schemas are being updates concurrently.

D : THREAD_ID 21 has stopped running.

E : The slave cannot process the relay log fast enough to use all threads.

F : The server needs more cores to use all slave threads.

Answer: A,B

Question 2

You have an InnoDB Cluster configured with three servers.Examine this command, which executes successfully:mysqldump -uroot -p -d mydatabase > mydatabase_backup.sqlDue 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 runningWhich two actions, either one of which, can fix this error and allow a successful restore of the cluster? (Choose two.)

Options :

A : Stop all instances except the primary read/write master instance and run the restore.

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

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

D : Remove the group replication plugin from each instance before restoring.

E : Remove the @@GLOBAL.gtid_executed statement from the dump file.

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

Answer: B,C

Question 3

You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.Which two conditions must be true? (Choose two.)

Options :

A : Each extra column in the copy with more columns must not have a default value.

B : Columns that are common to both versions of the table must be defined in the same order on the master and the slave.

C : The slave database cannot have more columns than the master. Only the master database can have more columns.

D : Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server.

E : The master database cannot have more columns than the slave. Only the slave deatbase can have more columns.

Answer: B,D

Question 4

Which query would you use to find connections that are in the same state for longer than 100 seconds?

Options :

A : SHOW FULL PROCESSLIST WHEER Time > 100;

B : SELECT * FROM INFORMATION_SCHEMA.EVENTS SHERE STARTS < (DATE_SUB (NOW ( ), INTERVAL 100 SECOND) );

C : SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE TIME > 100;

Answer: C

Question 5

Force Majeure is a catastrophic failure on a major level of the database operation. Regular backups are key to helping avoid data loss in such situations.Which two other steps can help avoid data loss in a major catastrophe? (Choose two.)

Options :

A : Implement a failover strategy to another geographic location.

B : Create a master-master pair for each service.

C : Have a second data centre in a different region or country.

D : Keep software updated to the latest version.

E : Use RAID 10 storage for data.

F : Use on-site network-attached storage to separate service from data.

Answer: A,C