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?
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. Reference: https://docs.microsoft.com/en-us/azure/mysql/concepts-query-store
Answer given is correct. Query performance insight in Azure Database for MySQL only cover long run query and wait statistics.
https://docs.microsoft.com/en-us/azure/mysql/concepts-query-performance-insight
Use Query Performance Insight if:
You're using Azure Database for MySQL.
You need a simple, integrated way to identify and analyze inefficient queries based on resource usage.
Answer given is correct.
The Query Store in MySQL allows you to track query performance over time and quickly identify the longest running and most expensive queries in your databases. The data for all users, databases, and queries is stored in the mysql schema database in your instance. Like Azure SQL Database, the Azure portal includes a Query Performance Insight dashboard, which highlights expensive queries and wait statistics for your instance.
https://docs.microsoft.com/en-us/learn/modules/configure-databases-performance/4-describe-query-store-azure-database-mysql-postgresql
it has to be C. this is from MS website.
https://docs.microsoft.com/en-us/azure/azure-sql/database/query-performance-insight-use
Query Performance Insight provides intelligent query analysis for single and pooled databases. It helps identify the top resource consuming and long-running queries in your workload. This helps you find the queries to optimize to improve overall workload performance and efficiently use the resource that you are paying for.
my bad, answer A is correct as question relates to MYSQL.
Query Performance Insight helps you to quickly identify what your longest running queries are, how they change over time, and what waits are affecting them.
the answer should be C
https://docs.microsoft.com/en-us/sql/relational-databases/performance/best-practice-with-the-query-store?view=sql-server-ver15
https://docs.microsoft.com/en-us/azure/azure-sql/database/query-performance-insight-use
Query Performance Insight is based upon Query Store. Maybe that's why the suggested answer is Query Store? I was torn between the two choices. I think this is one of the questions where there is more than one correct answer. Since QPI is based on QS perhaps that's the rationale?
why not Query Performance Insight? - Query Performance Insight helps you to quickly identify what your longest running queries are, how they change over time, and what waits are affecting them. https://docs.microsoft.com/en-us/azure/mysql/concepts-query-performance-insight
given answer is correct as question talk about the resources:
Query Store simplifies performance troubleshooting by helping you quickly find the longest running and most resource-intensive queries.
upvoted 4 times
...
...
This section is not available anymore. Please use the main Exam Page.DP-300 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
cck21
Highly Voted 4 years agoOga_DBA
Most Recent 4 months, 2 weeks ago2f5c7cd
5 months, 3 weeks agoxinter12
3 years, 4 months agoquermi
3 years, 4 months agoJas_dandiwal
4 years, 1 month agoJas_dandiwal
4 years, 1 month agoSaurav_Raghuvanshi2000
4 years, 1 month agomrwell
4 years, 1 month agoeezzykel
4 years, 1 month agoJohnCrawford
4 years, 3 months agoyuck
4 years, 2 months agoChengKuo
4 years, 4 months agogoodh32
4 years, 3 months ago