Microsoft Certified: Azure Database Administrator Associate DP-300 Syllabus Exam Questions Answers

There are CPU and Data I/O spikes for the PaaS prototype. Business Critical 4-vCore is needed.

Box 1: Yes

DBAGroup1 is member of the Contributor role.

The Contributor role grants full access to manage all resources, but does not allow you to assign roles in Azure RBAC, manage assignments in Azure Blueprints, or share image galleries.

Box 2: No

Box 3: Yes

DBAGroup2 is member of the SQL DB Contributor role.

The SQL DB Contributor role lets you manage SQL databases, but not access to them. Also, you can't manage their security-related policies or their parent SQL servers. As a member of this role you can create and manage SQL databases.

To generate an email alert to admin@contoso.com when CPU percentage utilization for db1 is higher than average, you can use the Azure portal to create an alert rule based on the CPU percentage metric. Here are the steps to do that:

• Go to the Azure portal and select your Azure SQL Database server that hosts db1.
• Select Alerts in the Monitoring section and click on New alert rule.
• In the Condition section, click Add and select the CPU percentage metric.
• In the Configure signal logic page, set the threshold type to Dynamic. This will compare the current metric value to the historical average and trigger the alert when it deviates significantly1.
• Set the operator to Greater than, the aggregation type to Average, the aggregation granularity to 1 minute, and the frequency of evaluation to 5 minutes.
• Click Done to save the condition.
• In the Action group section, click Create and enter a name and a short name for the action group.
• In the Notifications section, click Add and select Email/SMS message/Push/Voice.
• Enter admin@contoso.com in the Email field and click OK.
• Click OK to save the action group.
• In the Alert rule details section, enter a name and a description for the alert rule, choose a severity level, and make sure the rule is enabled.
• Click Create alert rule to create the alert rule.

This alert rule will send an email to admin@contoso.com when the CPU percentage utilization for db1 is higher than average. You can also add other actions to the alert rule, such as calling a webhook or running an automation script

To configure your user account as the Azure AD admin for the server named sql3700689S, you can use the Azure portal or the Azure CLI. Here are the steps for both methods:

• Using the Azure portal:
• Using the Azure CLI:

These are the steps to configure your user account as the Azure AD admin for the server named sql3700689S.