Designing and Implementing Microsoft DevOps Solutions — Question 28

Your company makes use of Azure SQL Database Intelligent Insights and Azure Application Insights for monitoring purposes.
You have been tasked with analyzing the monitoring using ad-hoc queries. You need to utilize the correct query language.
Solution: You use the Transact-SQL.
Does the solution meet the goal?

Answer options

• A. Yes
• B. No

Correct answer: B

Explanation

The proposed solution does not meet the goal because Azure Application Insights uses a different query language called Kusto Query Language (KQL) for analysis. While Transact-SQL is suitable for Azure SQL Database, it is not applicable for querying data in Azure Application Insights.