exam questions

Exam AZ-400 All Questions

View all questions & answers for the AZ-400 exam

Exam AZ-400 topic 1 question 29 discussion

Actual exam question from Microsoft's AZ-400
Question #: 29
Topic #: 1
[All AZ-400 Questions]

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?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
fanq10
Highly Voted 3 years, 5 months ago
You need to utilize the correct query language. Azure Log Analytics is NOT a query language. So Given answer is correct
upvoted 50 times
AzureJobsTillRetire
1 year, 11 months ago
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.
upvoted 12 times
...
marras
2 years, 6 months ago
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
upvoted 6 times
...
pdk88
2 years, 3 months ago
You are correct. Given answer is right.
upvoted 2 times
...
prabhjot
2 years, 2 months ago
yes azure Log analytics
upvoted 1 times
...
...
DSA_MSC
Highly Voted 3 years, 2 months ago
A - YES Same question: https://www.examtopics.com/discussions/microsoft/view/25631-exam-az-400-topic-7-question-4-discussion/
upvoted 16 times
[Removed]
3 years ago
hmm good point. From MS perspective it is Log Analytics but in reality its KQL
upvoted 4 times
...
basw77
2 years, 5 months ago
You're right. Based on the other options from that question, we can conclude is should the correct answer is Log Analytics.
upvoted 2 times
...
...
abhmala1
Most Recent 22 hours, 23 minutes ago
Selected Answer: A
answer can be yes tough log analytics is not a query languge
upvoted 1 times
...
OlehT
5 months ago
Selected Answer: A
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
upvoted 1 times
...
e0da014
6 months, 1 week ago
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
upvoted 1 times
...
Pillartech
7 months, 4 weeks ago
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
upvoted 2 times
...
saket051985
10 months, 3 weeks ago
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)
upvoted 1 times
...
Hgreg
1 year ago
Selected Answer: A
"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.
upvoted 2 times
...
kshk
1 year, 1 month ago
Selected Answer: B
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.
upvoted 2 times
...
gabo
1 year, 2 months ago
It's asking for the query language, so only KQL can be the correct answer.
upvoted 1 times
...
flafernan
1 year, 3 months ago
Selected Answer: B
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".
upvoted 1 times
...
yana_b
1 year, 4 months ago
Selected Answer: B
Should be yes when provided solution of this question is KQL (Kusto query language)
upvoted 1 times
...
itexamsmicrosoft
1 year, 5 months ago
Selected Answer: 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.
upvoted 2 times
...
Architects
1 year, 5 months ago
A - log analytics and it use Kusto QL
upvoted 1 times
...
Rouix
1 year, 5 months ago
Here I would go for A - YES! You will utilize correct query language via Log Analytics Workspace and its Kusto Query Language.
upvoted 1 times
...
zellck
1 year, 6 months ago
Selected Answer: B
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.
upvoted 3 times
...
yana_b
1 year, 6 months ago
Selected Answer: B
The primary query language used in Log Analytics is called Kusto Query Language (KQL)
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago