Here you have the best Microsoft AZ-304 practice exam questions
You need to recommend a solution to generate a monthly report of all the new Azure Resource Manager resource deployments in your subscription.
What should you include in the recommendation?
To generate a monthly report of all new Azure Resource Manager resource deployments in your subscription, you should include Azure Activity Log in your recommendation. Azure Activity Log provides detailed information on operations that were taken on resources within your subscription, including who initiated the actions, when they occurred, their status, and other relevant properties. This allows you to track and analyze deployments effectively.
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?
Query Performance Insight is a tool specifically designed for analyzing query performance in Azure SQL databases. It provides detailed insights into the performance of queries, including identifying the longest-running and most resource-intensive queries. This tool allows for a thorough analysis of query performance, facilitating the identification and optimization of queries to enhance overall database performance.
HOTSPOT -
You have an Azure App Service Web App that includes Azure Blob storage and an Azure SQL Database instance. The application is instrumented by using the
Application Insights SDK.
You need to design a monitoring solution for the web app.
Which Azure monitoring services should you use? To answer, select the appropriate Azure monitoring services in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Note: You can select Logs from either the Azure Monitor menu or the Log Analytics workspaces menu.
Reference:
https://docs.microsoft.com/en-us/azure/azure-monitor/log-query/log-query-overview
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.
NOTE: Each correct selection is worth one point.
To minimize the compute costs of the Azure virtual machines, it is recommended to activate Azure Hybrid Benefit and purchase Azure Reserved Virtual Machine Instances. Azure Hybrid Benefit allows you to use your existing on-premises Windows Server licenses with Software Assurance and run Windows virtual machines on Azure at a reduced cost. Purchasing Azure Reserved Virtual Machine Instances enables you to reserve virtual machines in advance, offering significant savings compared to pay-as-you-go prices, particularly for workloads with predictable consumption patterns.
HOTSPOT -
You have an Azure subscription that contains the SQL servers on Azure shown in the following table.
The subscription contains the storage accounts shown in the following table.
You create the Azure SQL databases shown in the following table.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
Box 1: Yes -
Be sure that the destination is in the same region as your database and server.
Box 2: No -
Box 3: No -
Reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-auditing