You have an Azure SQL managed instance named SQLMI1 that hosts 10 databases.
You need to implement alerts by using Azure Monitor. The solution must meet the following requirements:
✑ Minimize costs.
✑ Aggregate Intelligent Insights telemetry from each database.
What should you do?
To minimize costs and aggregate Intelligent Insights telemetry from each database in an Azure SQL managed instance, you should configure the diagnostic settings at the managed instance level rather than individually for each database. This centralizes the telemetry data, making it easier to manage and more cost-effective. Therefore, selecting 'Send to Log Analytics' from the Diagnostic settings of SQLMI1 is the appropriate choice.
The answer is C. C. From the Diagnostic settings of SQLMI1, select Send to Log Analytics. To implement alerts by using Azure Monitor, the best approach is to send diagnostic data from the Azure SQL managed instance to Log Analytics. This approach meets both requirements, as it aggregates telemetry data from each database and minimizes costs. With Log Analytics, you can centralize and analyze diagnostic data from different sources, including Azure SQL Managed Instances, and set up alerts based on specific conditions. Option A would require setting up diagnostic settings for each database individually, which can be time-consuming and difficult to manage. Option B would require creating an event hub for each database, which could result in increased costs and complexity.
Yes, but: To configure streaming of diagnostic telemetry for managed instance and instance databases, you will need to separately configure each: Enable streaming of diagnostic telemetry for managed instance Enable streaming of diagnostic telemetry for each instance database The managed instance container has its own telemetry separate from each instance database's telemetry. So, we need to do both. In that case for me the best answer is A as is needed. https://learn.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure?tabs=azure-portal&view=azuresql#configure-the-streaming-export-of-diagnostic-telemetry
Everyone should be careful about U_C, he always provides wrong answers randomly.
He has pasted most of the generative AI, Chat GPT etc content only.
https://docs.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure?tabs=azure-portal#configure-the-streaming-export-of-diagnostic-telemetry
https://learn.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure?tabs=azure-portal&view=azuresql#configure-the-streaming-export-of-diagnostic-telemetry "To configure streaming of diagnostic telemetry for managed instance and instance databases, you need to separately configure each: Enable streaming of diagnostic telemetry for managed instance Enable streaming of diagnostic telemetry for each instance database The managed instance container has its own telemetry separate from each instance database's telemetry." - so the provided answer is correct, we need to do it for each database.
You can use the Diagnostics settings menu in the Azure portal to enable and configure streaming of diagnostic telemetry. Additionally, you can use PowerShell, the Azure CLI, the REST API, and Resource Manager templates to configure streaming of diagnostic telemetry. You can set the following destinations to stream the diagnostic telemetry: Azure Storage, Azure Event Hubs, and Azure Monitor logs. https://learn.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure?view=azuresql&tabs=azure-portal#configure-the-streaming-export-of-diagnostic-telemetry
To configure streaming of diagnostic telemetry for managed instance and instance databases, you will need to separately configure each: Enable streaming of diagnostic telemetry for managed instance Enable streaming of diagnostic telemetry for each instance database The managed instance container has its own telemetry separate from each instance database's telemetry.