DP-300 Certification Practice Question #182

Question

You have a version-8.0 Azure Database for MySQL database.
You need to identify which database queries consume the most resources.
Which tool should you use?

Accepted Answer

To identify which specific queries consume the most resources in an Azure Database for MySQL instance, you should use Query Performance Insight (Option C). Query Performance Insight is the Azure portal visualization tool specifically designed to analyze Query Store telemetry and present a list of the top resource-consuming, long-running, and high-wait queries. While Query Store (Option A) is the underlying data collection technology that must be enabled first, Query Performance Insight is the user-facing tool that allows you to identify the resource-intensive queries with ease.

More DP-300 practice questions