Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 5 question 12 discussion

Actual exam question from Microsoft's DP-300

Question #: 12
Topic #: 5

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?

A. From the Diagnostic settings of each database, select Send to Log Analytics.
B. From the Diagnostic settings of each database, select Stream to an event hub.
C. From the Diagnostic settings of SQLMI1, select Send to Log Analytics.
D. From the Diagnostic settings of SQLMI1, select Stream to an event hub.

Show Suggested Answer

Suggested Answer: A 🗳️
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 setting.
4. Etc.
5. Repeat the above steps for each instance database you want to monitor.
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

by Aggie0702 at Sept. 23, 2021, 11:36 p.m.

Comments

Submit Cancel

U_C

Highly Voted 2 years, 4 months ago

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.

upvoted 5 times

stevenwong

1 year, 6 months ago

Everyone should be careful about U_C, he always provides wrong answers randomly.

upvoted 6 times

Sr18

1 year, 1 month ago

He has pasted most of the generative AI, Chat GPT etc content only.

upvoted 1 times

...

OBIJUAN88

2 years, 3 months ago

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

upvoted 5 times

...

MVFGrant

Most Recent 9 months, 2 weeks ago

when you said " Aggregate Intelligent Insights", with this you eliminate event hub, because you need a database for further analytics (eliminated option B and D)... so Log Analytics is a better option, and to compile all information , A is better than C

upvoted 1 times

...

Vitos25

10 months, 2 weeks ago

Selected Answer: A

I think the answer actually within the question "Aggregate Intelligent Insights telemetry from EACH database" In addition I do agree with OBIJUAN88 comment.

upvoted 1 times

...

igorclapa

1 year, 10 months ago

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

upvoted 1 times

...

testdumps2017

1 year, 11 months ago

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.

upvoted 2 times

...

HSQL

2 years, 5 months ago

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.

upvoted 1 times

...

Aggie0702

3 years, 10 months ago

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

upvoted 3 times

...