Query Language for Analyzing Azure SQL Database Intelligent Insights and Azure Application Insights
Question
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?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B.B
Data analysis in Azure SQL Analytics is based on Log Analytics language for your custom querying and reporting.
https://docs.microsoft.com/en-us/azure/azure-monitor/insights/azure-sqlThe solution of using Azure Log Analytics to analyze monitoring using ad-hoc queries does meet the goal.
Azure Log Analytics is a service that collects and analyzes data from different sources, including Azure SQL Database Intelligent Insights and Azure Application Insights. It provides a query language called Kusto Query Language (KQL) that can be used to analyze data and generate insights.
KQL is a powerful language that enables users to write ad-hoc queries to analyze data in real-time. It allows users to join data from different sources, filter and group data, and perform various calculations and aggregations.
Therefore, using Azure Log Analytics and KQL is an appropriate solution to analyze monitoring data from Azure SQL Database Intelligent Insights and Azure Application Insights. It provides the flexibility and power needed to analyze large amounts of data and generate insights quickly.
In conclusion, the solution of using Azure Log Analytics with KQL meets the goal of analyzing monitoring using ad-hoc queries.
