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?
Azure Log Analytics provides a platform for running queries using the Kusto Query Language (KQL). For analyzing monitoring data from Azure SQL Database Intelligent Insights and Azure Application Insights, KQL is the correct language to use. Log Analytics serves as the interface to write and execute these queries, hence using Azure Log Analytics achieves the goal of properly analyzing the data with the correct query language.
You need to utilize the correct query language. Azure Log Analytics is NOT a query language. So Given answer is correct
I'd prefer KQL however Microsoft calls Log Analytics also a language here: https://docs.microsoft.com/en-us/services-hub/health/log_analytics_query_language
You are correct. Given answer is right.
yes azure Log analytics
This is not correct. The question does not specifically ask which language you should use. It states that you need to utilize the correct query language, and you can do so by using Azure Log Analytics, which has KQL inside you can use.
A - YES Same question: https://www.examtopics.com/discussions/microsoft/view/25631-exam-az-400-topic-7-question-4-discussion/
hmm good point. From MS perspective it is Log Analytics but in reality its KQL
You're right. Based on the other options from that question, we can conclude is should the correct answer is Log Analytics.
B is the answer. https://learn.microsoft.com/en-us/azure/azure-monitor/logs/log-query-overview Azure Monitor Logs is based on Azure Data Explorer, and log queries are written by using the same Kusto Query Language (KQL). This rich language is designed to be easy to read and author, so you should be able to start writing queries with some basic guidance.
A is the correct answer. "Data analysis in Azure SQL Analytics is based on Log Analytics language for your custom querying and reporting." https://learn.microsoft.com/en-us/previous-versions/azure/azure-monitor/insights/azure-sql#analyze-data-and-create-alerts
"You need to utilize the correct query language." "Solution: You use Azure Log Analytics." - This sentence does not say that Azure Log Analytics is a language. It simply says, that you use this service, which means that you use KQL. KQL is a correct answer, so I vote for A.
Azure Log Analytics is not a query language. Kusto Query Language should be used for querying Application Insights and Azure Monitor. So, the correct answer is B.
B. No Azure Log Analytics is a service in Azure that provides comprehensive analytics and insights, not a query language itself. However, it uses Kusto Query Language (KQL), the same as Azure Application Insights and Azure SQL Database Intelligent Insights, for querying and analyzing the data. So, while Azure Log Analytics could potentially be part of a solution to analyze monitoring data, it isn't a query language as the question suggests. The correct query language for Azure Application Insights and Azure SQL Database Intelligent Insights is KQL.
The primary query language used in Log Analytics is called Kusto Query Language (KQL)
Data analysis in Azure SQL Analytics is based on Log Analytics language. Period, do not overthink. https://learn.microsoft.com/en-us/previous-versions/azure/azure-monitor/insights/azure-sql#analyze-data-and-create-alerts
Topic 2, Question 10 You use Azure SQL Database Intelligent Insights and Azure Application Insights for monitoring. You need to write ad-hoc queries against the monitoring data. Which query language should you use? A. Kusto Query Language (KQL) Most Correct query language is Kusto
While Azure Log Analytics is a powerful tool for analyzing and querying log data, it is not the primary tool for querying and analyzing data from Azure SQL Database Intelligent Insights and Azure Application Insights. Each of these services has its own query language. Answer is B(No)
It's asking for the query language, so only KQL can be the correct answer.
The proposed solution for using Azure Log Analytics to analyze monitoring data from Azure SQL Database Intelligent Insights and Azure Application Insights does not meet the objective, as each of these tools has its own dedicated query languages (T-SQL and Kusto Query Language, respectively). Log Analytics is not an add-on tool for this specific type of analysis. So the correct answer is "No".
Should be yes when provided solution of this question is KQL (Kusto query language)
A - log analytics and it use Kusto QL
Here I would go for A - YES! You will utilize correct query language via Log Analytics Workspace and its Kusto Query Language.
Azure Application Insights, you would use the Application Insights Analytics query language. This query language is based on a subset of the Kusto Query Language (KQL) and allows you to perform advanced analytics and querying on your application telemetry data.