CompTIA Data+ DA0-002 (V2) Practice Question

Performance Schema Reports use MySQL's SYS views to surface more than twenty ready-made performance reports, including "Full Table Scans," "Using Temp Tables," and "Statements in Highest 5 percent by Runtime." Because the reports are pre-built and draw directly from the Performance Schema, the analyst can review execution counts, latency, and rows examined for problematic statements with a single click-no manual EXPLAIN or custom queries required.

Visual Explain displays an execution plan for one statement at a time, so it does not provide an aggregated list of problematic queries. Performance Dashboard shows server-level graphs (I/O, buffer pool, network, etc.) but not per-statement statistics. The SQL Data Export wizard is intended for backing up or transferring schema objects and data, not for performance analysis.