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

View Answer

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