Home » Microsoft » AZ-400 v.2 » Which query language should you use?
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. Azure Log Analytics
B. PL/pgSQL
C. PL/SQL
D. Transact-SQL
Correct Answer: A
Explanation/Reference:
Data analysis in Azure SQL Analytics is based on Log Analytics language for your custom querying and reporting. References: https://docs.microsoft.com/en-us/azure/azure-monitor/insights/azure-sql