Exam DP-300 topic 18 question 1 discussion

Actual exam question from Microsoft's DP-300

Question #: 1
Topic #: 18

HOTSPOT -
You need to implement the monitoring of SalesSQLDb1. The solution must meet the technical requirements.
How should you collect and stream metrics? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

Box 1: The server, the elastic pool, and the database
Senario:
SalesSQLDb1 is in an elastic pool named SalesSQLDb1Pool.
Litware technical requirements include: all SQL Server and Azure SQL Database metrics related to CPU and storage usage and limits must be analyzed by using
Azure built-in functionality.

Box 2: Azure Event hubs -
Scenario: Migrate ManufacturingSQLDb1 to the Azure virtual machine platform.
Event hubs are able to handle custom metrics.
Incorrect Answers:

Azure Log Analytics -
Azure metric and log data are sent to Azure Monitor Logs, previously known as Azure Log Analytics, directly by Azure. Azure SQL Analytics is a cloud only monitoring solution supporting streaming of diagnostics telemetry for all of your Azure SQL databases.
However, because Azure SQL Analytics does not use agents to connect to Azure Monitor, it does not support monitoring of SQL Server hosted on-premises or in virtual machines.

by elgaz at March 15, 2021, 2:04 a.m.

Comments

Submit Cancel

OneplusOne

Highly Voted 2 years, 7 months ago

A: Elastic pool and databases B: Log Analytics Streaming to log analytics is possible: https://learn.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure?view=azuresql&tabs=azure-portal You can stream metrics and resource logs to a Log Analytics workspace in Azure Monitor. Data streamed here can be consumed by SQL Analytics (preview), which is a cloud only monitoring solution that provides intelligent monitoring of your databases that includes performance reports, alerts, and mitigation recommendations. Data streamed to a Log Analytics workspace can be analyzed with other monitoring data collected and also enables you to leverage other Azure Monitor features such as alerts and visualizations. https://learn.microsoft.com/en-us/azure/azure-sql/database/monitor-tune-overview?view=azuresql Collecting server metrics is not an option: https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-resource-management?view=azuresql

upvoted 10 times

licna

2 years, 6 months ago

Agree. Log Analytics is for inspecting metrics by Azure built-in tools (I guess MS wants to hear Kusto Query Language + set up alert based on the results). Event Hubs -> Stream metrics to other locations. Used to be integrated with other vendors tools https://learn.microsoft.com/en-us/azure/azure-monitor/essentials/stream-monitoring-data-event-hubs

upvoted 2 times

...

Ziggybooboo

Highly Voted 4 years, 4 months ago

Further to my previous comment the below is in the scenario: All SQL Server and Azure SQL Database metrics related to CPU and storage usage and limits must be analyzed by using Azure built-in functionality.

upvoted 7 times

...

bingomutant

Most Recent 9 months, 3 weeks ago

To implement the monitoring of SalesSQLDb1 and meet the technical requirements, here's how you should configure the options: Collect metrics from: The server, the elastic pool, and the database - This option will collect metrics at every layer, including the SQL Server instance, the elastic pool, and individual databases. This provides comprehensive coverage of all possible metrics across different levels. Stream metrics to: Azure Log Analytics - This option allows you to stream metrics to a centralized service where you can analyze them in real time, create dashboards, and set up alerts. It is well-suited for in-depth analysis and is integrated into Azure Monitor, which aligns with the requirement to monitor SQL Server and Azure SQL Database metrics related to CPU and storage usage.

upvoted 1 times

...

Ben999

1 year, 4 months ago

Elastic pool and databases. Log Analytics. Allows the use of a single dashboard to monitor all metrics from Azure resources; and SalesSQLDB1 is in an Azure Elastic Pool.

upvoted 1 times

...