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?
Click on the arrows to vote for the correct answer
A. B. C. D.A
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-overviewThe query language that should be used to write ad-hoc queries against the monitoring data from Azure SQL Database Intelligent Insights and Azure Application Insights is Kusto Query Language (KQL).
KQL is a query language used to query large, structured, semi-structured, and unstructured datasets stored in Azure Data Explorer, Azure Monitor Logs, and other Azure services. It is optimized for analyzing large volumes of data and allows for efficient querying of data across distributed sources.
PL/pgSQL and PL/SQL are procedural languages used for writing stored procedures, triggers, and functions in PostgreSQL and Oracle databases, respectively. These languages are not suitable for querying monitoring data in Azure SQL Database Intelligent Insights and Azure Application Insights.
Transact-SQL (T-SQL) is a dialect of SQL used by Microsoft SQL Server and Azure SQL Database. While T-SQL can be used to query data from Azure SQL Database Intelligent Insights, it is not the recommended query language for querying data from Azure Application Insights.
Therefore, the correct answer is A. Kusto Query Language (KQL).