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?

The correct answer is C. Kusto Query Language (KQL). Azure Monitor Logs is based on Azure Data Explorer, and log queries are written using the same Kusto query language (KQL). This is a rich language designed to be easy to read and author, and you should be able to start using it with minimal guidance. https://docs.microsoft.com/en

Submitted by the_admin· Mar 6, 2026Implement an instrumentation strategy

Question

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?

Options

APL/pgSQL
BTransact-SQL
CKusto Query Language (KQL)
DPL/SQL

How the community answered

(35 responses)

A
9% (3)
B
3% (1)
C
86% (30)
D
3% (1)

Explanation

Azure Monitor Logs is based on Azure Data Explorer, and log queries are written using the same Kusto query language (KQL). This is a rich language designed to be easy to read and author, and you should be able to start using it with minimal guidance. https://docs.microsoft.com/en-us/azure/azure-monitor/log-query/log-query-overview

Community Discussion

No community discussion yet for this question.

Full AZ-400 Practice