You have an Azure SQL managed instance that hosts multiple databases. You need to configure alerts for each database based on the diagnostics telemetry of the database. What should you use?
A.
Azure SQL Analytics alerts based on metrics
B.
SQL Health Check alerts based on diagnostics logs
C.
SQL Health Check alerts based on metrics
D.
Azure SQL Analytics alerts based on diagnostics logs
Suggested Answer:D🗳️
You can use Azure SQL Analytics for monitoring and alerting. You can easily create alerts with the data coming from Azure SQL Database resources. Here are some useful log queries that you can use with a log alert: Example, HIGH CPU:
AzureMetrics - | where ResourceProvider=="MICROSOFT.SQL" | where ResourceId contains "/DATABASES/" | where MetricName=="cpu_percent" | summarize AggregatedValue = max(Maximum) by bin(TimeGenerated, 5m) | render timechart Note: Azure Monitor Logs is based on Azure Data Explorer, and log queries are written using the same Kusto query language (KQL). Reference: 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
For the standard, event-based monitoring experience, select the following check boxes for database diagnostics log telemetry: SQLInsights, AutomaticTuning, QueryStoreRuntimeStatistics, QueryStoreWaitStatistics, Errors, DatabaseWaitStatistics, Timeouts, Blocks, and Deadlocks.
https://learn.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure?view=azuresql&tabs=azure-portal
This section is not available anymore. Please use the main Exam Page.DP-300 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
KIET2131
8 months, 1 week agoOneplusOne
9 months, 3 weeks agoo2091
1 year, 11 months ago