DP-300 · Question #213
You have an Azure SQL database. You need to identify a long-running query. Here you need to identify which operation in the question is causing a performance issue. Which of the following can be…
The correct answer is A. Live Query Statistics. With Live Query statistics, you get real-time information and insights on the queries as they are running. This allows you to debugging query performance issues, such as long-running queries, and queries that run indefinitely and never finish. Option B is incorrect since this…
Question
Options
- ALive Query Statistics
- BAn estimated execution plan
- CAn actual execution plan
- DClient Statistics
How the community answered
(16 responses)- A94% (15)
- C6% (1)
Explanation
With Live Query statistics, you get real-time information and insights on the queries as they are running. This allows you to debugging query performance issues, such as long-running queries, and queries that run indefinitely and never finish. Option B is incorrect since this will only give you what could be the plan that is going to be used Option C is incorrect since this will not give live statistics that can show which query is causing an Option D is incorrect since this will not give the server stats that will show the performance of the https://docs.microsoft.com/en-us/sql/relational-databases/performance/query-profiling- infrastructure?view=sql-server-ver15
Community Discussion
No community discussion yet for this question.