You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1 and a Log Analytics workspace named Workspace1. You need to collect performance metrics for SQLMI1 and stream th

The correct answer is D. Modify the diagnostic settings for SQLMI1.. Diagnostic settings available for databases in your Azure SQL Managed Instance include: log: SQL Insights, Query Store Runtime Statistics, Query Store Wait Statistics, and Errors destination details: Send to Log Analytics workspace, Archive to a storage account, Stream to an even

Submitted by fatima_kr· Mar 6, 2026Monitor, configure, and optimize database resources

Question

You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1 and a Log Analytics workspace named Workspace1. You need to collect performance metrics for SQLMI1 and stream the metrics to Workspace. What should you do first?

Options

ACreate a private endpoint connection on SQLMI1.
BConfigure Azure SQL Analytics to use Workspace1.
CModify the Compute + storage settings for SQLMI1.
DModify the diagnostic settings for SQLMI1.

How the community answered

(22 responses)

A
5% (1)
C
5% (1)
D
91% (20)

Explanation

Diagnostic settings available for databases in your Azure SQL Managed Instance include: log: SQL Insights, Query Store Runtime Statistics, Query Store Wait Statistics, and Errors destination details: Send to Log Analytics workspace, Archive to a storage account, Stream to an event hub, Send to partner solution https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/monitoring-sql-managed- instance-azure-monitor?view=azuresql#collection-and-routing

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice