Examine this SQL statement:

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

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

An attempt to recover an InnoDB Cluster fails.
Examine this set of messages and responses:
host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage() Reconfiguring the default cluster from complete outage...
The instance 'host1:3377'' was part of the cluster configuration. Would you like to rejoin it to the cluster?
[y/N]: y
The instance 'host2:3377' was part of the cluster configuration. Would you like to rejoin it to the cluster?
[y/N]: y
Dba.rebootClusterFromCompleteOutage: The active session instance isn't the most updated in comparison with the ONLINE instances of the Cluster's metadata. Please use the most up to date instance: 'host1:3377'.
(RuntimeError)
Which statement is true?

• A. The active session instance is invalid and must be re-created by using the command shell.connect ('host3:3377').
• B. The instance deployed on host3 must be rebuilt with a backup from the primary instance.
• C. The cluster is running and there is at least one ONLINE instance.
• D. The instance deployed on host3 must be synchronized from a donor deployed on host1 by using the command cluster.addInstance('host1:3377').
• E. It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET(set1,set2).

Examine this statement, which executes successfully:

Now examine this query:

Which two statements can do this? (Choose two.)

• A. ALTER TABLE employees -
  ADD INDEX ((CAST(birth_date->>'$.month' AS unsigned)));
• B. ALTER TABLE employees -
  ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (birth_date->>'$.month') VIRTUAL NOT NULL, ADD INDEX (birth_month);
• C. ALTER TABLE employees -
  ADD INDEX (birth_date);
• D. ALTER TABLE employees -
  ADD INDEX (birth_date DESC);
• E. ALTER TABLE employees -
  ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (MONTH(birth_date)) VIRTUAL NOT NULL, ADD INDEX (birth_month);
• F. ALTER TABLE employees -
  ADD INDEX ((MONTH(birth_date)));

Examine these statements, which execute successfully:
CREATE ROLE r_world_rd;
GRANT SELECT ON world.* TO r_world_rd;
CREATE USER john IDENTIFIED BY 'P@ssw0rd';
GRANT r_world_rd TO john;
Examine these statements issued by user John:

What is the reason for the error?

• A. The statement was blocked by MySQL Firewall.
• B. John needs to reconnect to the database.
• C. The DBA needs to execute FLUSH PRIVILEGES.
• D. John has not activated the role.

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 group replication will buffer the transactions on the online nodes until the unreachable nodes return online.
• B. A manual intervention to force group members to be only the working two instances is required.
• C. The cluster will shut down to preserve data consistency.
• D. 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.
• E. The cluster has built-in high availability and updates group_replication_ip_whitelist to remove the unreachable nodes.