AZ-305

You have an Azure subscription that contains an Azure SQL database named DB1.

Several queries that query the data in DB1 take a long time to execute.

You need to recommend a solution to identify the queries that take the longest to execute.

What should you include in the recommendation?

• SQL Database Advisor

• Azure Monitor

• Performance Recommendations

• Query Performance Insight

You have an on-premises Hyper-V cluster. The cluster contains Hyper-V hosts that run Windows Server 2016 Datacenter. The hosts are licensed under a

Microsoft Enterprise Agreement that has Software Assurance.

The Hyper-V cluster contains 30 virtual machines that run Windows Server 2012 R2. Each virtual machine runs a different workload. The workloads have predictable consumption patterns.

You plan to replace the virtual machines with Azure virtual machines that run Windows Server 2016. The virtual machines will be sized according to the consumption pattern of each workload.

You need to recommend a solution to minimize the compute costs of the Azure virtual machines.

Which two recommendations should you include in the solution? Each correct answer presents part of the solution.

• Configure a spending limit in the Azure account center.

• Create a virtual machine scale set that uses autoscaling

• Activate Azure Hybrid Benefit for the Azure virtual machines

• Purchase Azure Reserved Virtual Machine Instances for the Azure virtual machines.

• Create a lab in Azure DevTest Labs and place the Azure virtual machines in the lab

A company has a hybrid ASP.NET Web API application that is based on a software as a service (SaaS) offering.

Users report general issues with the data. You advise the company to implement live monitoring and use ad hoc queries on stored JSON data. You also advise the company to set up smart alerting to detect anomalies in the data.

You need to recommend a solution to set up smart alerting.

What should you recommend?

• Azure Site Recovery and Azure Monitor Logs

• Azure Data Lake Analytics and Azure Monitor Logs

• Azure Application Insights and Azure Monitor Logs

• Azure Security Center and Azure Data Lake Store

You have an Azure subscription that is linked to an Azure Active Directory (Azure AD) tenant. The subscription contains 10 resource groups, one for each department at your company.

Each department has a specific spending limit for its Azure resources.

You need to ensure that when a department reaches its spending limit, the compute resources of the department shut down automatically.

Which two features should you include in the solution? Each correct answer presents part of the solution.

• Azure Logic Apps

• Azure Monitor alerts

• the spending limit of an Azure account

• Cost Management budgets

• Azure Log Analytics alerts

You are designing an Azure resource deployment that will use Azure Resource Manager templates. The deployment will use Azure Key Vault to store secrets.

You need to recommend a solution to meet the following requirements:

✑ Prevent the IT staff that will perform the deployment from retrieving the secrets directly from Key Vault.

✑ Use the principle of least privilege.

Which two actions should you recommend? Each correct answer presents part of the solution

• Create a Key Vault access policy that allows all get key permissions, get secret permissions, and get certificate permissions

• From Access policies in Key Vault, enable access to the Azure Resource Manager for template deployment

• Create a Key Vault access policy that allows all list key permissions, list secret permissions, and list certificate permissions

• Assign the IT staff a custom role that includes the Microsoft.KeyVault/Vaults/Deploy/Action permission

• Assign the Key Vault Contributor role to the IT staff

You have an Azure Active Directory (Azure AD) tenant.

You plan to provide users with access to shared files by using Azure Storage. The users will be provided with different levels of access to various Azure file shares based on their user account or their group membership.

You need to recommend which additional Azure services must be used to support the planned deployment.

What should you include in the recommendation?

• an Azure AD enterprise application

• Azure Information Protection

• an Azure AD Domain Services (Azure AD DS) instance

• an Azure Front Door instance

You plan to deploy an application named App1 that will run on five Azure virtual machines. Additional virtual machines will be deployed later to run App1.

You need to recommend a solution to meet the following requirements for the virtual machines that will run App1:

✑ Ensure that the virtual machines can authenticate to Azure Active Directory (Azure AD) to gain access to an Azure key vault, Azure Logic Apps instances, and an Azure SQL database.

✑ Avoid assigning new roles and permissions for Azure services when you deploy additional virtual machines.

✑ Avoid storing secrets and certificates on the virtual machines.

✑ Minimize administrative effort for managing identities.

• a service principal that is configured to use a certificate

• a system-assigned managed identity

• a service principal that is configured to use a client secret

• a user-assigned managed identity

You are designing a large Azure environment that will contain many subscriptions.

You plan to use Azure Policy as part of a governance solution.

To which three scopes can you assign Azure Policy definitions? Each correct answer presents a complete solution.

• management groups

• subscriptions

• Azure Active Directory (Azure AD) tenants

• resource groups

• Azure Active Directory (Azure AD) administrative units

You have an Azure subscription. The subscription has a blob container that contains multiple blobs.

Ten users in the finance department of your company plan to access the blobs during the month of April.

You need to recommend a solution to enable access to the blobs during the month of April only.

Which security solution should you include in the recommendation?

• access keys

• conditional access policies

• certificates

• shared access signatures (SAS)

You have an Azure subscription.

You need to recommend a solution to provide developers with the ability to provision Azure virtual machines. The solution must meet the following requirements:

✑ Only allow the creation of the virtual machines in specific regions.

✑ Only allow the creation of specific sizes of virtual machines.

What should you include in the recommendation?

• Azure Resource Manager templates

• Azure Policy

• conditional access policies

• role-based access control (RBAC)