You have a multi-tier application that has an Azure Web Apps front end and an Azure SQL Database back end.
You need to recommend a solution to capture and store telemetry data. The solution must meet the following requirements:
✑ Support using ad-hoc queries to identify baselines.
✑ Trigger alerts when metrics in the baseline are exceeded.
✑ Store application and database metrics in a central location.
What should you include in the recommendation?
Azure Application Insights is well-suited for capturing and storing telemetry data for a multi-tier application with an Azure Web Apps front end and an Azure SQL Database back end. It supports the use of ad-hoc queries to identify baselines, can trigger alerts when metrics exceed the baseline, and centrally stores both application and database metrics. Application Insights is designed specifically for application performance monitoring and can provide detailed insights into both the performance and usage of the application components, making it the ideal solution for this scenario.
I think answer should be Log Analytics What kind of telemetry data is being handled by Log Analytics ? -> Data related to infrastructure and network level i.e., few of them are syslogs, IIS logs, custom logs, windows events, windows and linux performance counters, etc. For more information, please refer https://docs.microsoft.com/en-us/azure/azure-monitor/azure-monitor-log-hub What kind of telemetry data is being handled by App Insights ? -> Data related to code-level application performance level i.e., few of them are ping URL tests, page view counts, page view load data, HTTP requests, dependency calls, exceptions and stack traces, custom events and metrics that you code, trace logs, AJAX calls, user and session counts, run-time exceptions, failure anomalies, abnormal rise in exceptions, etc. For more information, please refer https://docs.microsoft.com/en-us/azure/azure-monitor/azure-monitor-app-hub and https://docs.microsoft.com/en-us/azure/azure-monitor/app/troubleshoot-faq#what-telemetry-is-collected-by-application-insights
We need to store application and database metrics. According to provided links app logs should be handled by App Insights. Why did you choose LA then
Its C, Cause in Log Analytics you can run the Queries + You can set triggers for alerts. and centralized Database Management.
✑ Store application and database metrics in a central location. Taking this account answer should be D. As Log analytics is the place where can query data after saving log to it.
With multi-tier application we need a common place to query logs of each service. So The answer is correct => Log Analytics
they have a condition "Store application and database metrics in a central location." Application Insights is not a centralised location. There for Log Analytics is correct.
Application Insights can store data in Log Analytics workspaces
Yes, but why should we choose AI then? If we use Log Analytics for storing
Yes, but why should we choose AI then? If we use Log Analytics for storing
from chatGPT: However, Azure Log Analytics does not provide some of the advanced application monitoring capabilities that are available in Azure Application Insights, such as automatic collection of telemetry data from web apps and services, and built-in support for identifying and diagnosing performance and availability issues.
Option D, **Azure Log Analytics**, is not the best solution for capturing and storing telemetry data in this scenario because it is primarily used for collecting and analyzing data from different sources . It does not support ad-hoc queries to identify baselines or trigger alerts when metrics in the baseline are exceeded . It also does not store application and database metrics in a central location . Therefore, Azure Log Analytics does not meet all of the requirements for capturing and storing telemetry data. References: : Microsoft. (n.d.). What is Log Analytics? https://docs.microsoft.com/en-us/azure/azure-monitor/logs/log-analytics-overview
Apparently the answer is: D. Azure Log Analytics >Collecting, storing, and analyzing log data from various sources (Multi-tier application) >Powerful query language for querying log data (Support using ad-hoc queries to identify baselines) >Alerts based on log data (Trigger alerts when metrics in the baseline are exceeded) >Centralize and correlate logs for monitoring, troubleshooting across your environment (Store application and database metrics in a central location) Azure Application Insights, focused on application performance monitoring, well-suited for monitoring web applications, APIs(doesn't fit to multi-tier applications as well as Log Analytics), and itself is not a centralized location for storing data.
Both Log Analytics and Application Insights meets almost all requirements EXCEPT database Telemetry. This is only achieved via Log Analytics, while Application Insights track dependencies with SQL services, but almost no more. Answer: D. Log Analytics
Log Analytics will not "Trigger alerts when metrics in the baseline are exceeded."
I Think right answer is C
azure log analytics
Log Analytics is the accurate answer, as it stores data related to network
This is D for sure
C and D: While both Azure Application Insights and Log Analytics can meet the question's requirements, Microsoft likely chose to consider Log Analytics as the correct answer because it is more widely used for collecting and analyzing telemetry data in cloud environments. Log Analytics is a powerful tool that provides advanced analytics and insights to help monitor and troubleshoot cloud applications and infrastructure. Additionally, Log Analytics is highly integrated into the Azure ecosystem, making it a natural choice for this type of scenario. However, it is important to note that Azure Application Insights is also a valid and effective option for capturing and analyzing telemetry data in web applications. Both solutions can be successfully used to meet the requirements mentioned in the question.
Thank you ChatGPT
It is C.
Log Analytics-- Application Insights does not store data. Application Insights is a layer on top of Log Analytics aimed at application-level telemetry and uses the log data stored in Log Analytics to provide an additional bunch of features that make App Insights an Application Performance Management tool
Log analytics for me. Someone mentioned in the comments that we cannot create alert rules in log. That is incorrect, we can create alerts on custom log queries just like insight alert rules
These tools are used together but since we need a broader monitoring solution, I go with Log Analytics. Azure Application Insights: This is your application's performance and health specialist, providing automatic insights into user behavior, response times, and code-level diagnostics. It's the quickest way to understand what is happening within your application. Azure Log Analytics: This is your comprehensive data investigator for your entire system, allowing you to collect, analyze, and query logs and metrics from any source. It's the power tool for understanding how and when things happen across your infrastructure and applications through flexible queries and custom alerts.
It should be C
Why is it C?
Answer is correct as I do not believe Application Insights has querying capabilities.
Application INsights has a querying capability with a sql-like language: kusto But SQL doesn't log to AI, but Log Analytics. So the answer is correct because AI doesn't provide a single location log storage
Application INsights has a querying capability with a sql-like language: kusto But SQL doesn't log to AI, but Log Analytics. So the answer is correct because AI doesn't provide a single location log storage
Right answer would have been Azure Monitor. Both App Insights and Log Analytics are parts of AM.
Here Log analytics seems to be the right answer. It supports ad hoc qs, central location for storing all logs, and can be used to configure alerts. Intelligent Insights and Azure SQL analytics can run on those data as well.
More correct is Azure Monitor https://docs.microsoft.com/en-us/azure/azure-monitor/learn/tutorial-response Alerts are set based on metrics which are not an output of Azure Log Analytics (Logs). If we have to choose from the options, Azure Application Insights are more appropriate.
Application Insights, a feature of Azure Monitor, is an extensible Application Performance Management (APM) service for developers and DevOps professionals..It can monitor and analyze telemetry from mobile apps by integrating with Visual Studio App Center.
Explore, filter, and segment aggregated data such as rates of requests, failures, and exceptions; response times, page load times. Explore the components of your app, with key metrics and alerts. Set up automatic alerts that adapt to your app's normal patterns of telemetry and trigger when there's something outside the usual pattern. You can also set alerts on particular levels of custom or standard metrics.
C. From chatgpt, Based on the requirements, the best recommendation would be to use Azure Application Insights. Application Insights supports ad-hoc queries and alerting when metrics exceed baselines. It also stores application and database metrics in a central location, making it easy to monitor and analyze the data. While Azure Log Analytics could also be used to store and analyze telemetry data, it does not have built-in support for ad-hoc queries or alerting based on metrics exceeding baselines. Azure Event Hubs is primarily used for event streaming and real-time data ingestion, and while Azure SQL Database Intelligent Insights provides database performance monitoring and recommendations, it does not support monitoring of the application tier or alerting based on metrics exceeding baselines.
From Claude: C. Azure Application Insights ✓ Supports ad-hoc queries through Kusto Query Language (KQL) ✓ Has built-in smart detection and alerting capabilities ✓ Stores both application and database telemetry ✓ Provides baseline deviation detection ✓ Offers centralized monitoring solution D. Azure Log Analytics While it supports queries and alerts More focused on infrastructure and log analysis Would require additional configuration for application metrics Better suited for operational logs rather than application telemetry The correct answer is C. Azure Application Insights.
Does Application Insights store database metrics? I think no, but one of the requirements is "Store application and database metrics in a central location." I'm not familiar with Azure SQL Database Intelligent Insights but I assume it only cares about the database logs and metrics Azure Event Hubs, you can't use ad-hoc queries So the answer is Azure Log Analytics
I think D since we need both metrics UI and SQL
The correct is D. Azure Log Analytics provides central storage capabilities. You could configure both the Web App and SQL Database to send data directly to Log Analytics.