Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam DP-300 Topic 12 Question 16 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 16
Topic #: 12
[All DP-300 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: A

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 MySQL instance.


https://docs.microsoft.com/en-us/azure/mysql/concepts-query-store

Comments

Currently there are no comments in this discussion, be the first to comment!


Save Cancel