You are using Azure SQL Database Intelligent Insights and Azure Application Insights for monitoring and need to run ad-hoc queries against the monitoring data. Which query language should you use?
Choose an answer
Tap an option to check your answer.
Correct answer: Kusto Query Language (KQL).
Why this is the answer
Kusto Query Language (KQL) is the correct choice because both Azure SQL Database Intelligent Insights and Azure Application Insights store their monitoring data in Azure Monitor Logs, which uses KQL for querying. KQL is specifically designed for querying large volumes of structured, semi-structured, and unstructured data in a read-only fashion. PL/pgSQL is a procedural language for PostgreSQL, and PL/SQL is for Oracle databases; neither is used for querying Azure monitoring data. Transact-SQL (T-SQL) is used for querying SQL Server and Azure SQL Database transactional data, not for the log data collected by Azure Monitor services like Application Insights or Intelligent Insights.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed