FREE Microsoft AZ-304 Questions and Answers
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?
For both single and pooled databases, Query Performance Insight offers sophisticated query analysis. It aids in locating the most resource-intensive and time-consuming queries in your job. This aids in the discovery of the queries that need to be improved in order to increase workload performance overall and make effective use of the resource you are paying for.
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?
Peak performance and steady workloads are provided by continual performance tweaking based on AI and machine learning for Azure SQL Database and Azure SQL Managed Instance.
Automatic tuning is a fully managed intelligent performance service that continuously monitors queries run on a database and optimizes their performance automatically.
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.
Please select 2 correct answers
‥ Microsoft Azure Hybrid Benefit for Windows Server allows clients with Software Assurance to use their on-premises Windows Server licenses and run
Reduced-cost Windows virtual computers on Azure. Azure Hybrid Benefit for Windows Server can be used to deploy fresh virtual machines running the Windows operating system.
‥ You may reserve virtual machines in advance and save up to 80% using Azure Reserved VM Instances (RIs).
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?
For developers and DevOps experts, Application Insights, an attribute of Azure Monitor, is an extensible Application Performance Management (APM) tool.
Use it to keep an eye on your running programs. Powerful analytics capabilities are built in to help you identify problems and comprehend how users actually use your app, and it will instantly detect performance irregularities.
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.
Please select 2 correct answers
- The Azure spending cap stops you from going over your credit limit. The spending limit is switched on by default for all new customers who join up for an Azure free account or subscription types that include credits over several months. The spending cap is fixed at the credit limit and cannot be increased.
- After removing the spending cap, activate it.
Only when the spending cap has been permanently eliminated for membership kinds that include credits spread over numerous months is this function accessible. With the help of this feature, you may set your spending cap to activate automatically at the beginning of the subsequent billing cycle.
1. Sign in to the Azure portal as the Account Administrator.
2. Search for Cost Management + Billing.
3. Etc.
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?
The Azure portal's Log Analytics tool is used to update and execute log searches using information from Azure Monitor Logs. To sort, filter, and analyze a set of records that are returned by a straightforward query, use Log Analytics' functionality. Alternately, you might create a more complex query to carry out statistical analysis and display the results in a chart to spot a specific pattern.
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?
For 90 days, activity logs are kept. If the starting date is less than 90 days in the past, you can query for any range of dates.
Activity records allow you to ascertain:
‥ what actions were performed with respect to the resources in your subscription
‥ Who initiated the action?
‥ the time the procedure took place
‥ the operation's status
‥ The values of additional characteristics that could aid your investigation of the operation