ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam
Go to Exam

Exam DP-300 topic 4 question 8 discussion

Actual exam question from Microsoft's DP-300
Question #: 8
Topic #: 4
[All DP-300 Questions]

You have an Azure SQL database.
Users report that the executions of a stored procedure are slower than usual. You suspect that a regressed query is causing the performance issue.
You need to view the query execution plan to verify whether a regressed query is causing the issue. The solution must minimize effort.
What should you use?

  • A. Performance Recommendations in the Azure portal
  • B. Extended Events in Microsoft SQL Server Management Studio (SSMS)
  • C. Query Store in Microsoft SQL Server Management Studio (SSMS)
  • D. Query Performance Insight in the Azure portal
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by Nishitan at June 10, 2021, 4:47 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Nishitan
Highly Voted 4 years, 1 month ago
The answer is correct verified in microsoft docoument
upvoted 18 times
...
bingomutant
Most Recent 9 months, 1 week ago
- Query Store in SSMS is specifically designed to track query performance over time, including execution plans, runtime statistics, and performance regressions. It automatically captures and retains historical execution plans, which allows you to easily compare current and past execution plans to identify regressions. It provides a low-effort solution for troubleshooting performance issues and regressed queries, as the information is readily available without needing to set up additional monitoring tools.
upvoted 1 times
...
bsk1983
1 year, 10 months ago
Selected Answer: C
https://learn.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver16#Regressed
upvoted 3 times
...
vcloudpmp
2 years ago
https://learn.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver16 Use the Regressed Queries feature.
upvoted 1 times
...
yousiftech
2 years ago
Selected Answer: D
"Query Performance Insight" (option D) in the Azure portal.
upvoted 1 times
Dalamain
1 year, 3 months ago
Did you read the Microsoft documentation before posting that - because if you had you'd know there is nothing mentioned about being able to view an execution plan via QPI..... https://learn.microsoft.com/en-us/azure/azure-sql/database/query-performance-insight-use?view=azuresql your welcome
upvoted 2 times
...
...
Chunchi
3 years, 5 months ago
C: is correct
upvoted 2 times
...
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.

SaveCancel