MySQL 8.0 Database Administrator — Question 37

You have configured MySQL Enterprise Monitor to monitor your MySQL server.
Which four features are available? (Choose four.)

Answer options

• A. starting and stopping the MySQL instance
• B. tracing import and export with mysqidump
• C. deploying the MySQL agent on supported target operating system
• D. creating e-mail alerts and SNMP traps for MySQL warnings
• E. monitoring the availability of the MySQL instance
• F. analyzing executed MySQL queries
• G. monitoring of NDB Cluster API nodes

Correct answer: B, D, E, F

Explanation

The correct features offered by MySQL Enterprise Monitor include tracing import and export with mysqidump (B), creating email alerts and SNMP traps for MySQL warnings (D), monitoring the availability of the MySQL instance (E), and analyzing executed MySQL queries (F). Options A and C are not core features of the monitoring tool, and option G relates to a specific database architecture not covered by the Enterprise Monitor.