DP-300 Question #168: Real Exam Question with Answer & Explanation

Question

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?

Options

• AFrom the Diagnostic settings of each database, select Send to Log Analytics.
• BFrom the Diagnostic settings of each database, select Stream to an event hub.
• CFrom the Diagnostic settings of SQLMI1, select Send to Log Analytics.
• DFrom the Diagnostic settings of SQLMI1, select Stream to an event hub.

Explanation

Databases in Azure SQL Managed Instance You can set up an instance database resource to collect the following diagnostic telemetry: To enable streaming of diagnostic telemetry for an instance database, follow these steps: 1. Go to instance database resource within managed instance. 2. Select Diagnostics settings. 3. Select Turn on diagnostics if no previous settings exist, or select Edit setting to edit a previous 5. Repeat the above steps for each instance database you want to monitor. 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-

No community discussion yet for this question.