DP-300 Certification Practice Question #293

Question

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:

Accepted Answer

SalesSQLDb1 is an Azure SQL Database hosted in an Elastic Pool. In Azure SQL Database, database-level and elastic pool-level metrics are collected via diagnostic settings configured directly on the database or elastic pool resources. A logical Azure SQL Server does not have direct diagnostic settings for streaming CPU/storage metrics. Therefore, metrics should be collected from "The elastic pool and the database". To meet the technical requirement to analyze these metrics using Azure built-in functionality, they must be streamed to "Azure Log Analytics", which allows querying via Kusto Query Language (KQL) and setting up alerts natively in Azure Monitor.

More DP-300 practice questions