You have an Azure Database for MySQL database. You have to identify which database queries are consuming the most resources. Which of the following tool can be used for this requirement?

The correct answer is A. Query Store. The Query Store feature in Azure Database for MySQL provides a way to track query performance over time. Query Store simplifies performance troubleshooting by helping you quickly find the longest running and most resource-intensive queries. Query Store automatically captures a…

Submitted by ravi_2018· Mar 6, 2026Optimize query performance

Question

You have an Azure Database for MySQL database. You have to identify which database queries are consuming the most resources. Which of the following tool can be used for this requirement?

Options

AQuery Store
BMetrics
CQuery Performance Insight
DAlerts

How the community answered

(32 responses)

A
91% (29)
B
6% (2)
D
3% (1)

Explanation

The Query Store feature in Azure Database for MySQL provides a way to track query performance over time. Query Store simplifies performance troubleshooting by helping you quickly find the longest running and most resource-intensive queries. Query Store automatically captures a history of queries and runtime statistics, and it retains them for your review. It separates data by time windows so that you can see database usage patterns. Data for all users, databases, and queries is stored in the mysql schema database in the Azure Database for https://docs.microsoft.com/en-us/azure/mysql/concepts-query-store

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice