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

Question

SIMULATION You need to generate an email alert to [email protected] when CPU percentage utilization for db1 is higher than average. To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal. Answer: Create a CPU status alert for a SQL Server on Azure Create a metric alert with dynamic thresholds (Create an alert when a CPU exceeds an average) Step 1: In the search bar at the top of the Azure portal, type SQL, and select SQL databases. Select the AdventureWorksLT database name listed.[Here db1] Step 2: On the main blade for the database, navigate down to the monitoring section. Select Alerts. Step 3: Select Create alert rule. Step 4: In the Select a signal slide out, select CPU percentage. Step 5: In the Configure signal slide out, select Dynamic for the Threshold property Step 6: Then check that the Operator property is Greater than, the Aggregation type is Average. Select Done. (There is no Threshold value) Step 7: Select the Actions tab. Step 8: In the Actions tab, select Create action group. Step 9: On the Action Group screen, type emailgroup in the Action group name field, and then select Next: Notifications. Step 10: On the Notifications tab, enter the following information: Notification type: Email/SMS message/Push/Voice Note: When you select this option, a Email/SMS message/Push/Voice flyout will appear. Check the Email property and type: [[email protected]] Step 11: Select Review + create, then select Create. Note: Dynamic thresholds apply advanced machine learning and use a set of algorithms and methods to: Learn the historical behavior of metrics Analyze metrics over time and identify patterns such as hourly, daily or weekly patterns Recognize anomalies that indicate possible service issues Calculate the most appropriate threshold for the metric When you use dynamic thresholds, you don't have to know the "right" threshold for each metric, because dynamic thresholds calculate the most appropriate thresholds for you. Reference: https://microsoftlearning.github.io/dp-300-database-administrator/Instructions/Labs/12-create- cpu-status-alert.html https://learn.microsoft.com/en-us/azure/azure-monitor/alerts/alerts-dynamic-thresholds

Options

• taskGenerate an email alert to [email protected] when CPU percentage utilization for db1 is higher than average.
• prerequisitesAzure portal access