There are five MySQL instances configured with a working group replication.
Examine the output of the group members:

Which two statements are true about network partitioning in the cluster? (Choose two.)

• A.The cluster has built-in high availability and updates group_replication_ip_whitelistto remove the unreachable nodes.
• B.The group replication will buffer the transactions on the online nodes until the unreachable nodes return online.
• C.There could be both a 2 node and 3 node group replication still running, so shutting down group replication and diagnosing the issue is recommended.
• D.The cluster will shut down to preserve data consistency.
• E.A manual intervention to force group members to be only the working two instances is required.

Comment: *

Name: *

Email: *

Verification: *

Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)

• A.InnoDB Data Dictionary
• B.doublewrite buffer
• C.table data
• D.user privileges
• E.primary indexes
• F.change buffer

Comment: *

Name: *

Email: *

Verification: *

Examine this SQL statement:

Which set of privileges will allow Tom to execute this SQL statement?

• A.GRANT UPDATE ON 'world'.* TO 'tom'@'%';
  GRANT ALL PRIVILEGES ON 'world'.'country' TO 'tom'@'%';
• B.GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.* TO 'tom'@'%';
• C.GRANT ALL PRIVILEGES ON 'world'.'city' TO 'tom'@'%';
  GRANT SELECT ('code') ON 'world'.'country' TO 'tom'@'%';
• D.GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.'country' TO 'tom'@'%';

Comment: *

Name: *

Email: *

Verification: *

An existing asynchronous replication setup is running MySQL 8.
Which two steps are a part of implementing GTID replication? (Choose two.)

• A.On the slave, alter the MySQL master connection setting with:
  CHANGE MASTER TO MASTER_AUTO_POSITION = 1;
• B.Enable GTID by executing this on the master and the slave:
  SET GLOBAL GTID_ENABLED=on;
• C.Execute this on the slave to enable GTID:
  RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC;
• D.Execute this on the slave to enable GTID:
  START SLAVE IO_THREAD WITH GTID;
• E.Restart MySQL (master and slave) with these options enabled:
  --gtid_mode=ON
  --log-bin
  --log-slave-updates
  --enforce-gtid-consistency
• F.On the slave, alter the MySQL master connection setting with:
  ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1;

Comment: *

Name: *

Email: *

Verification: *

Which two are true about binary logs used in asynchronous replication? (Choose two.)

• A.They are pushed from the master to the slave.
• B.They contain events that describe database changes on the master.
• C.They contain events that describe all queries run on the master.
• D.They contain events that describe only administrative commands run on the master.
• E.They are pulled from the master to the slave.

Comment: *

Name: *

Email: *

Verification: *