Exam AZ-400 topic 1 question 29 discussion

You need to utilize the correct query language. Azure Log Analytics is NOT a query language. So Given answer is correct

A - YES Same question: https://www.examtopics.com/discussions/microsoft/view/25631-exam-az-400-topic-7-question-4-discussion/

Azure Log Analytics is the right tool for analyzing monitoring data using ad-hoc queries. It uses the Kusto Query Language (KQL) to query and analyze data collected from: Azure Application Insights: Provides telemetry data like request rates, response times, and failure rates. Azure SQL Database Intelligent Insights: When integrated, logs diagnostic and performance data into Log Analytics.

The confusion here arises from the distinction between Azure Log Analytics as a service and the query language it uses, which is Kusto Query Language (KQL). To clarify: Azure Log Analytics is a service that allows you to aggregate and analyze data from various Azure resources, including Azure SQL Database and Azure Application Insights. KQL is the query language used within Azure Log Analytics to perform ad-hoc queries and retrieve insights. When the question asks about utilizing the "correct query language," it is referring to the query language used within the Azure Log Analytics platform, which is KQL. So, in the context of the question, using Azure Log Analytics is indeed the correct approach because it leverages KQL to analyze data. Conclusion: The answer of A. Yes is correct because Azure Log Analytics uses KQL, which is the correct query language for analyzing the monitoring data from both Azure SQL Database Intelligent Insights and Azure Application Insights.

answer can be yes tough log analytics is not a query languge

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

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

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)

"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.

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)

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.

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.