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 the Transact-SQL.
Does the solution meet the goal?
Click on the arrows to vote for the correct answer
A. B.B
https://docs.microsoft.com/en-us/azure/azure-monitor/insights/azure-sqlThe solution mentioned in the question of using Transact-SQL for analyzing monitoring using ad-hoc queries is not completely accurate because Transact-SQL is the query language used for querying and managing relational databases such as Azure SQL Database.
Azure Application Insights is a service provided by Microsoft Azure to monitor and diagnose issues in web applications and services. It provides various features like logging, telemetry, and analytics, which can be used to extract insights from the monitored data. Application Insights uses its own query language called Application Insights Analytics, which is based on Kusto Query Language (KQL). KQL is a powerful and flexible query language used to query and analyze data from various Azure services, including Azure Application Insights.
On the other hand, Azure SQL Database Intelligent Insights is a feature of Azure SQL Database that provides intelligent performance insights into the performance of SQL databases. It uses machine learning to detect performance anomalies and provide recommendations to improve database performance. To analyze and extract insights from the data provided by Azure SQL Database Intelligent Insights, Transact-SQL can be used. However, it is important to note that Transact-SQL cannot be used to query and analyze data from Azure Application Insights.
Therefore, the correct answer to the question is B, i.e., No, the solution of using Transact-SQL does not meet the goal of analyzing monitoring using ad-hoc queries for both Azure SQL Database Intelligent Insights and Azure Application Insights. Kusto Query Language (KQL) should be used for analyzing monitoring data from Azure Application Insights, whereas Transact-SQL should be used for analyzing data from Azure SQL Database Intelligent Insights.