MySQL 8.0 Database Administrator — Question 89

Which two statements are true about using MySQL Enterprise Monitor Query Analyzer? (Choose two.)

Answer options

• A. The single query QRTi pie chart in the Query Analyzer view is based on the average execution of all statements.
• B. It is possible to retrieve a normalized statement, but never the exact statement that was executed.
• C. It is possible to configure the Query Analysis built-in advisor to get notified about slow query execution.
• D. It is possible to list and analyze statements in an arbitrary graph range selection from timeseries graphs.
• E. It is possible to import data into the Query Analyzer from heterogeneous sources, such as CSV.

Correct answer: C, D

Explanation

Option C is correct because the Query Analysis advisor can indeed notify users about slow query executions. Option D is also correct as it allows users to analyze statements over any selected range in time series graphs. The other options are incorrect because A misrepresents the QRTi pie chart's basis, B inaccurately states the retrieval capabilities, and E incorrectly suggests data import capabilities that are not supported.