MySQL 8.0 Database Administrator — Question 102

Which statement is true about displaying and retrieving data with MySQL Enterprise Monitor Query Analyzer?

Answer options

• A. The Query Analyzer graph view range selector can extend to cover the same hour over multiple days.
• B. It is possible to filter a Query Analyzer view graph by database and by table.
• C. The Query Analyzer can plot a CPU utilization graph for remote hosts with a MySQL Enterprise Service Manager's built-in Agent installation.
• D. It is possible to export statements included in a graph selection in CSV format.

Correct answer: D

Explanation

The correct answer is D because the Query Analyzer allows users to export selected graph statements in CSV format for further analysis. Option A is incorrect as the range selector does not span multiple days in the same hour. Option B is wrong because filtering by database and table is not a feature of the Query Analyzer. Option C is inaccurate since the Query Analyzer does not generate CPU utilization graphs for remote hosts.