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

Exam AZ-304 All Questions

View all questions & answers for the AZ-304 exam
Go to Exam

Exam AZ-304 topic 1 question 2 discussion

Actual exam question from Microsoft's AZ-304
Question #: 2
Topic #: 1
[All AZ-304 Questions]

You have an Azure subscription that contains an Azure SQL database named DB1.
Several queries that query the data in DB1 take a long time to execute.
You need to recommend a solution to identify the queries that take the longest to execute.
What should you include in the recommendation?

  • A. SQL Database Advisor
  • B. Azure Monitor
  • C. Performance Recommendations
  • D. Query Performance Insight
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by speedminer at Sept. 7, 2020, 11:56 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
speedminer
Highly Voted 4 years, 7 months ago
Per the provided link: "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."
upvoted 34 times
sanketshah
4 years, 3 months ago
D is correct
upvoted 8 times
...
...
David_986969
Highly Voted 4 years, 5 months ago
In the exam 11/11/2020
upvoted 10 times
...
Aquib_Chiniwala
Most Recent 2 years, 6 months ago
Selected Answer: D
D is correct
upvoted 1 times
...
Aquib_Chiniwala
2 years, 6 months ago
D is correct
upvoted 1 times
...
cz65rv
2 years, 9 months ago
Selected Answer: D
Given answer is correct
upvoted 1 times
...
Hary001
2 years, 11 months ago
looks like correct ANS
upvoted 1 times
...
hertino
3 years ago
In AZ-305 exam, 9 april 22
upvoted 6 times
...
Odidepse
3 years ago
D is correct
upvoted 2 times
...
plmmsg
3 years, 1 month ago
D. Query Performance Insight
upvoted 1 times
...
Azure_daemon
3 years, 2 months ago
Query Performance Insight is the correct answer
upvoted 2 times
...
awalao
3 years, 4 months ago
Selected Answer: D
D is correct.
upvoted 2 times
...
sharepoint_Azure_pp
3 years, 6 months ago
Option D is correct or can say i choose the same. was there in 17th October 2021 cleared with 900
upvoted 3 times
...
syu31svc
3 years, 7 months ago
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. Query Performance Insight helps you spend less time troubleshooting database performance by providing: Deeper insight into your databases resource (DTU) consumption Details on top database queries by CPU, duration, and execution count (potential tuning candidates for performance improvements) Answer is D 100%
upvoted 3 times
...
heamgu
3 years, 10 months ago
D. Query Performance Insight
upvoted 1 times
...
yeanlingmedal71
3 years, 11 months ago
D is correct
upvoted 3 times
...
betamode
4 years, 2 months ago
Correct answer
upvoted 1 times
...
suryareddy
4 years, 3 months ago
D is correct
upvoted 3 times
...
Load full discussion...
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago