Microsoft AZ-304 Flashcards

To create a monthly report of all the new Azure Resource Manager resource deployments in your subscription, you must suggest a solution. What should the recommendation contain?

Answer: Azure Activity Log

The Azure Activity Log provides a historical record of subscription-level events, including resource deployments, creation, updates, and deletions. It is the primary source for tracking operations performed on resources in an Azure subscription. Therefore, it is the ideal service to query for a monthly report of new Azure Resource Manager resource deployments.

You have a subscription to Azure, which includes the DB1 Azure SQL database. The execution of several queries that examine the data in DB1 takes a lengthy time. The queries that take the longest to run must be identified, and a remedy must be suggested. What should the recommendation contain?

Answer: Query Performance Insight

Query Performance Insight for Azure SQL Database is specifically designed to identify the top consuming queries, detect performance bottlenecks, and provide actionable recommendations. It offers detailed insights into query execution statistics, helping to pinpoint which queries are taking the longest to run and why. This makes it the most direct and effective tool for identifying and remedying slow queries.

You have a Hyper-V cluster installed locally. Hyper-V hosts running Windows Server 2016 Datacenter are part of the cluster. The hosts are authorized by a Software Assurance Enterprise Agreement for Microsoft. There are 30 virtual machines running Windows Server 2012 R2 in the Hyper-V cluster. The burden that each virtual machine executes varies. The workloads have consistent patterns of consumption. You intend to swap out the virtual machines with Windows Server 2016-powered Azure virtual machines. The size of the virtual machines will be determined by how much power each workload consumes. To reduce the computational costs of the Azure virtual machines, you must suggest a solution. Which two suggestions ought to be incorporated into the solution? Each right response offers a piece of the answer.

Answer: Activate Azure Hybrid Benefit for the Azure virtual machines.

Azure Hybrid Benefit allows customers with existing Windows Server licenses with Software Assurance to use them on Azure VMs, significantly reducing compute costs. Purchasing Azure Reserved Virtual Machine Instances provides substantial discounts (up to 72%) compared to pay-as-you-go pricing for VMs, in exchange for committing to a one-year or three-year term. Both strategies are highly effective for reducing computational costs for Azure virtual machines.

A business has a software as a service (SaaS)-based hybrid ASP.NET Web API application. Users complain that the data generally has problems. You suggest that the business deploy live monitoring and utilize ad hoc queries on JSON data that has been stored. You also suggest that the business set up intelligent alerts to find data irregularities. You must include a suggestion for how to set up smart alerting. What would you suggest?

Answer: Azure Application Insights and Azure Monitor Logs

Azure Application Insights is excellent for live monitoring of web applications, collecting performance data, usage patterns, and exceptions, and supports intelligent alerts for anomalies. Azure Monitor Logs (formerly Log Analytics) allows for storing and performing ad hoc queries on various log data, including JSON, making it suitable for analyzing stored data and detecting irregularities. Together, they provide a comprehensive solution for monitoring, querying, and intelligent alerting for the described SaaS application.

Your Azure Active Directory (Azure AD) tenancy is connected to your Azure subscription. Ten resource groups are included in the subscription, one for each department at your business. Each department's Azure resource budget is limited in a unique way. You must make sure that a department's computing resources shut down automatically when it reaches its spending cap. What two features ought to be incorporated into the solution? Each right response offers a piece of the answer.

Answer: the spending limit of an Azure account

Azure's spending limit, when enabled, automatically suspends all resources in a subscription once the spending amount reaches the limit, providing a hard stop. Cost Management budgets allow you to set a threshold for your spending at various scopes (like a resource group for a department) and trigger alerts or actions (e.g., via Azure Logic Apps) when that threshold is approached or exceeded. Both features are crucial for managing and enforcing spending caps, with budgets offering more granular control for departmental limits.

You have a number of tables in your DB1 Azure SQL database. You must enhance DB1's performance. The answer must require the least amount of administration. Which should you employ?

Answer: automatic tuning

Azure SQL Database's automatic tuning feature continuously monitors query performance and automatically applies recommended index and query plan optimizations. It learns from the workload and adapts over time, requiring minimal administrative effort. This makes it the ideal solution for enhancing performance with the least amount of administration, as it automates the optimization process.

To create a monthly report of all the new Azure Resource Manager resource deployments in your subscription, you must suggest a solution. What should the recommendation contain?

Answer: Azure Log Analytics

Azure Log Analytics, part of Azure Monitor, is a service that collects, indexes, and stores log data from various sources, including the Azure Activity Log. While the Activity Log itself records the deployments, Log Analytics provides advanced querying capabilities (Kusto Query Language) and reporting features to easily create detailed monthly reports on resource deployments. It offers a more robust solution for analysis and presentation than just viewing the raw Activity Log.