Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us [email protected]
Menu

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Microsoft Discussions

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 🗳️
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.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/query-performance-insight-use
by speedminer at Sept. 7, 2020, 11:56 a.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
speedminer
Highly Voted 3 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
3 years, 3 months ago
D is correct
upvoted 8 times
...
...
David_986969
Highly Voted 3 years, 5 months ago
In the exam 11/11/2020
upvoted 10 times
...
Aquib_Chiniwala
Most Recent 1 year, 6 months ago
Selected Answer: D
D is correct
upvoted 1 times
...
Aquib_Chiniwala
1 year, 6 months ago
D is correct
upvoted 1 times
...
cz65rv
1 year, 9 months ago
Selected Answer: D
Given answer is correct
upvoted 1 times
...
Hary001
1 year, 11 months ago
looks like correct ANS
upvoted 1 times
...
hertino
2 years ago
In AZ-305 exam, 9 april 22
upvoted 6 times
...
Odidepse
2 years ago
D is correct
upvoted 2 times
...
plmmsg
2 years, 1 month ago
D. Query Performance Insight
upvoted 1 times
...
Azure_daemon
2 years, 2 months ago
Query Performance Insight is the correct answer
upvoted 2 times
...
awalao
2 years, 4 months ago
Selected Answer: D
D is correct.
upvoted 2 times
...
sharepoint_Azure_pp
2 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
2 years, 6 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
2 years, 10 months ago
D. Query Performance Insight
upvoted 1 times
...
yeanlingmedal71
2 years, 11 months ago
D is correct
upvoted 3 times
...
betamode
3 years, 2 months ago
Correct answer
upvoted 1 times
...
suryareddy
3 years, 3 months ago
D is correct
upvoted 3 times
...
Load full discussion...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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