Designing and Implementing Microsoft DevOps Solutions — Question 26

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 Azure Log Analytics.
Does the solution meet the goal?

Answer options

• A. Yes
• B. No

Correct answer: B

Explanation

The solution does not meet the goal because Azure Log Analytics uses its own query language called Kusto Query Language (KQL), which is not suitable for querying Azure SQL Database or Application Insights directly. Instead, you should use T-SQL for Azure SQL Database queries and the Application Insights Analytics query for Application Insights data.