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?

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 andres_qro· Mar 6, 2026Monitor, configure, and optimize database resources

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?

Options

AQuery Store
BMetrics
CQuery Performance Insight
DAlerts

How the community answered

(40 responses)

A
93% (37)
C
3% (1)
D
5% (2)

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