- All Exams Instant Download
What should you include in the recommendation?
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
Answer: D
Explanation:
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
Latest AZ-304 Dumps Valid Version with 238 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
Subscribe
Login
0 Comments
Inline Feedbacks
View all comments