Exam AZ-304 All Questions

View all questions & answers for the AZ-304 exam

Exam AZ-304 topic 1 question 2 discussion

Actual exam question from Microsoft's AZ-304

Question #: 2
Topic #: 1

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

Suggested Answer: D 🗳️

by speedminer at Sept. 7, 2020, 11:56 a.m.

Comments

Submit Cancel

speedminer

Highly Voted 4 years, 11 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, 7 months ago

D is correct

upvoted 8 times

...

David_986969

Highly Voted 4 years, 9 months ago

In the exam 11/11/2020

upvoted 10 times

...

Aquib_Chiniwala

Most Recent 2 years, 9 months ago

Selected Answer: D

D is correct

upvoted 1 times

...

Aquib_Chiniwala

2 years, 9 months ago

D is correct

upvoted 1 times

...

cz65rv

3 years ago

Selected Answer: D

Given answer is correct

upvoted 1 times

...

Hary001

3 years, 2 months ago

looks like correct ANS

upvoted 1 times

...

hertino

3 years, 4 months ago

In AZ-305 exam, 9 april 22

upvoted 6 times

...

Odidepse

3 years, 4 months ago

D is correct

upvoted 2 times

...

plmmsg

3 years, 5 months ago

D. Query Performance Insight

upvoted 1 times

...

Azure_daemon

3 years, 6 months ago

Query Performance Insight is the correct answer

upvoted 2 times

...

awalao

3 years, 8 months ago

Selected Answer: D

D is correct.

upvoted 2 times

...

sharepoint_Azure_pp

3 years, 10 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, 10 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

...