Valid AZ-304 Dumps shared by ExamDiscuss.com for Helping Passing AZ-304 Exam! ExamDiscuss.com now offer the newest AZ-304 exam dumps, the ExamDiscuss.com AZ-304 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com AZ-304 dumps with Test Engine here:
Access AZ-304 Dumps Premium Version
(288 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 75/84
You have an Azure SQL database named DB1 that contains multiple tables.
You need to improve the performance of DB1. The solution must minimize administrative effort.
What should you use?
You need to improve the performance of DB1. The solution must minimize administrative effort.
What should you use?
Correct Answer: A
Azure SQL Database and Azure SQL Managed Instance automatic tuning provides peak performance and stable workloads through continuous performance tuning based on AI and machine learning.
Automatic tuning is a fully managed intelligent performance service that uses built-in intelligence to continuously monitor queries executed on a database, and it automatically improves their performance.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-overview
Automatic tuning is a fully managed intelligent performance service that uses built-in intelligence to continuously monitor queries executed on a database, and it automatically improves their performance.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-overview
- Question List (84q)
- Question 1: You are designing an Azure solution. The network traffic for...
- Question 2: Note: This question is part of series of questions that pres...
- Question 3: You have an Azure blueprint named BP1. The properties of BP1...
- Question 4: You use Azure Application Insights. You plan to use continuo...
- Question 5: You need to recommend a solution for protecting the content ...
- Question 6: You have an Azure Storage v2 account named storage1. You pla...
- Question 7: You are designing a virtual machine that will run Microsoft ...
- Question 8: You need to recommend a data storage solution that meets the...
- Question 9: You have an Azure subscription. You need to recommend a solu...
- Question 10: You plan to create an Azure environment that will contain a ...
- Question 11: Your company deploys several Linux and Windows virtual machi...
- Question 12: You are designing a software as a service (SaaS) application...
- Question 13: Your company has 300 virtual machines hosted in a VMware env...
- Question 14: You have 100 Standard_F2s_v2 Azure virtual machines. Each vi...
- Question 15: You are designing a microservices architecture that will be ...
- Question 16: Your company deploys an Azure App Service Web App. During te...
- Question 17: You have an Azure Active Directory (Azure AD) tenant. You pl...
- Question 18: Your on-premises network contains a server named Server1 tha...
- Question 19: Note: This question is part of a series of questions that pr...
- Question 20: You are designing a solution that will host 20 different web...
- Question 21: You plan to create a storage account and to save the files a...
- Question 22: You have an Azure Active Directory (Azure AD) tenant named c...
- Question 23: You need to recommend a solution to deploy containers that r...
- Question 24: You are designing an Azure web app that will use Azure Activ...
- Question 25: You design a solution for the web tier of WebApp1 as shown i...
- Question 26: You plan to import data from your on-premises environment in...
- Question 27: You have an Azure Active Directory (Azure AD) tenant and Win...
- Question 28: You have 70 TB of files on your on-premises file server. You...
- Question 29: You have an app named App1 that uses two on-premises Microso...
- Question 30: You plan to create an Azure environment that will have a roo...
- Question 31: You need to deploy resources to host a stateless web app in ...
- Question 32: You are planning an Azure Storage solution for sensitive dat...
- Question 33: You have an Azure subscription that contains the SQL servers...
- Question 34: Your company has the infrastructure shown in the following t...
- Question 35: You need to recommend a notification solution for the IT Sup...
- Question 36: You have an Azure subscription that contains an Azure SQL da...
- Question 37: You have an Azure subscription that contains a custom applic...
- Question 38: Your on-premises network contains a file server named Server...
- Question 39: Your organization has developed and deployed several Azure A...
- Question 40: You need to recommend a strategy for the web tier of WebApp1...
- Question 41: You have an Azure subscription that contains an Azure Blob s...
- Question 42: You have an Azure subscription. The subscription contains Az...
- Question 43: You have an Azure Storage account that contains the data sho...
- Question 44: You need to recommend a solution for the data store of the h...
- Question 45: Note: This question is part of a series of questions that pr...
- Question 46: Your company has the offices shown in the following table. (...
- Question 47: You plan to create an Azure environment that will have a roo...
- Question 48: You plan to store data in Azure Blob storage for many years....
- Question 49: You need to recommend a solution for the collection of secur...
- Question 50: You are planning an Azure solution that will host production...
- Question 51: You store web access logs data in Azure Blob storage. You pl...
- Question 52: You have Azure virtual machines that run a custom line-of-bu...
- Question 53: You have a web application that uses a MongoDB database. You...
- Question 54: Your company plans to publish APIs for its services by using...
- Question 55: You have 500 Azure web apps in the same Azure region. The ap...
- Question 56: You need to recommend a solution to generate a monthly repor...
- Question 57: A company named Contoso Ltd., has a single-domain Active Dir...
- Question 58: You need to recommend a backup solution for the data store o...
- Question 59: You need to recommend a solution to generate a monthly repor...
- Question 60: You have an Azure subscription that is linked to an Azure Ac...
- Question 61: You have an existing implementation of Microsoft SQL Server ...
- Question 62: You have an Azure subscription. The subscription contains an...
- Question 63: Your company provides customer support for multiple Azure su...
- Question 64: You have an on-premises network and an Azure subscription. T...
- Question 65: Note: This question is part of a series of questions that pr...
- Question 66: Your company purchases an app named App1. You need to recomm...
- Question 67: You need to recommend an Azure Storage Account configuration...
- Question 68: Your company is designing a multi-tenant application that wi...
- Question 69: You have 100 servers that run Windows Server 2012 R2 and hos...
- Question 70: Note: This question is part of a series of questions that pr...
- Question 71: You need to recommend a solution for the users at Contoso to...
- Question 72: You have an Azure Active Directory (Azure AD) tenant named C...
- Question 73: You have an Azure subscription that contains the resources s...
- Question 74: You need to deploy resources to host a stateless web app in ...
- Question 75: You have an Azure SQL database named DB1 that contains multi...
- Question 76: You need to recommend a solution for implementing the back-e...
- Question 77: You ate designing a SQL database solution. The solution will...
- Question 78: Yontainers. Each pod deployment will host a separate API Eac...
- Question 79: You configure OAuth2 authorization in API Management as show...
- Question 80: What should you include in the identity management strategy ...
- Question 81: You nave 200 resource groups across 20 Azure subscriptions. ...
- Question 82: You need to recommend a high-availability solution for the m...
- Question 83: You plan to deploy an Azure web app named Appl that will use...
- Question 84: You have an Azure App Service Web App that includes Azure Bl...
