Exam DP-300 topic 3 question 44 discussion

Actual exam question from Microsoft's DP-300

Question #: 44
Topic #: 3

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?

A. Create a private endpoint connection on SQLMI1.
B. Configure Azure SQL Analytics to use Workspace1.
C. Modify the Compute + storage settings for SQLMI1.
D. Modify the diagnostic settings for SQLMI1.

Show Suggested Answer

Suggested Answer: D 🗳️

by BrenFa101 at Feb. 13, 2023, 4:09 p.m.

Comments

Submit Cancel

Pranava_GCP

8 months ago

Selected Answer: D

D is correct, to 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 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

upvoted 1 times

...