Consider this shell output and executed commands:
[root@oel7 ~]# ps aux | grep mysqld
mysql 2076 3.5 24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid
[root@oel7 ~]# kill -15 2076
Which statement is true about MySQL server shutdown?

• A.kill -15 should be avoided. Use other methods such as mysqladmin shutdown or systemctl stop mysqld.
• B.kill -15 and kill -9 are effectively the same forced shutdown that risk committed transactions not written to disk.
• C.kill -15 carries out a normal shutdown process, such as mysqladmin shutdown.
• D.mysqld_safe prohibits commands that would harm the operation of the server. An error would be returned by the kill command.

Comment: *

Name: *

Email: *

Verification: *

A MySQL server is monitored using MySQL Enterprise Monitor's agentless installation.
Which three features are available with this installation method? (Choose three.)

• A.CPU utilization
• B.security-related advisor warnings
• C.operating system memory utilization
• D.disk usage and disk characteristics including disk advisors warnings
• E.MySQL Query Analysis data
• F.MySQL Replication monitoring
• G.network-related information and network characteristics

Comment: *

Name: *

Email: *

Verification: *

Examine these commands and output:

Which connection ID is holding the metadata lock?

• A.25
• B.24
• C.22
• D.20
• E.21
• F.6

Comment: *

Name: *

Email: *

Verification: *

You must run multiple instances of MySQL Server on a single host.
Which three methods are supported? (Choose three.)

• A.Use system tools to lock each instance to its own CPU.
• B.Use systemd with different settings for each instance.
• C.Start mysqld or mysqld_safe using different option files for each instance.
• D.Run MySQL Server docker containers.
• E.Run mysqld with --datadir defined for each instance.
• F.Use resource groups to lock different instances on separate CPUs.

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *