DP-300 Question #409: Real Exam Question with Answer & Explanation

Question

SIMULATION You need to generate an email alert for db1 if the average CPU percentage utilization is greater than 50 percent for five minutes sampled at one-minute intervals. The alert must be sent to [email protected]. You may need to use SQL Server Management Studio and the Azure portal. Answer: To create an email alert for high CPU percentage utilization in an Azure database within the Azure portal, you'll first need to navigate to your database resource, then to the "Alerts" section. From there, you'll create a new alert rule, define the CPU percentage threshold, configure an action group for email notifications, and finally, create the alert rule. Create alerts for Azure SQL Database and Azure Synapse Analytics using the Azure portal Step 1: In the Azure portal, locate the resource you are interested in monitoring and select it. [Select db1] Step 2: In the resource menu under Monitoring, select Alerts. The text and icon might vary slightly for different resources. Step 3: Select the + Create button, then Alert rule. Step 4: On the Create an alert rule page, the Scope is automatically configured to the individual resource. Capture activity peaks or sustained resource stress with alerts on the Metrics signal category. Step 5: On the Condition tab, select See all signals and Select a signal from the list of Metrics. Step 6: Select the desired metric, for example CPU percentage. Select Apply. [Select CPU percentage] Step 7: After you select a signal, the Alert logic options appear. A preview of recent activity in this resource for that signal is also displayed. Step 8: Configure a Threshold type to determine when the alert will take action. Choose Aggregation type, Operator, and Threshold value as desired. A typical threshold is: Static, Maximum, Greater than, 80%. Threshold: [Select 50%] Operator: [Select Greater than] Aggregation granularity: [Select 5 minutes] Select the interval that's used to group the data points by using the aggregation type function. Choose an Aggregation granularity (period) that's greater than the Frequency of evaluation to reduce the likelihood of missing the first evaluation period of an added time series. Frequency of evaluation: [Select one minute] Select how often the alert rule is to be run. Select a frequency that's smaller than the aggregation granularity to generate a sliding window for the evaluation. Step 9: Under When to evaluate, determine the desired frequency of evaluation. Use the Check every and Lookback period dropdown lists. Step 10: Optionally, you can add multiple conditions for this alert, choose the Add condition alert if desired. Step 11: Select Next: Actions >. Create the new alert rule Step 12: Use the Use quick actions feature to create a new action group and provide an email or Azure mobile app notification target. Reference: https://learn.microsoft.com/en-us/azure/azure-sql/database/alerts-create?

Options

• taskGenerate an email alert for db1 in Azure for high CPU percentage utilization (greater than 50% for five minutes, sampled at one-minute intervals), sending the alert to [email protected].
• prerequisitesAzure portal access

Explanation

The correct answer walks through the precise Azure portal workflow for creating a metric-based alert rule on an Azure SQL Database resource. By navigating to the db1 resource → Monitoring → Alerts → Create Alert Rule, you define the CPU Percentage metric with a threshold of >50%, an aggregation period of 5 minutes, and a 1-minute evaluation frequency, then attach an Action Group configured with the email address [email protected]. This is the supported, documented method for configuring proactive monitoring alerts in Azure Monitor for Azure SQL Database resources.

No community discussion yet for this question.