<< Prev Question Next Question >>

Question 142/147

You have an Azure SQL managed instance named SQLMI1 that hosts 10 databases.
You need to implement alerts by using Azure Monitor. The solution must meet the following requirements:
* Minimize costs.
* Aggregate Intelligent Insights telemetry from each database.
What should you do?

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (147q)
Question 1: Note: This question is part of a series of questions that pr...
Question 2: You need to recommend a configuration for ManufacturingSQLDb...
Question 3: You have an Azure SQL Database managed instance named SQLMI1...
Question 4: You have an Azure SQL database that contains a table named E...
Question 5: You have SQL Server on an Azure virtual machine named SQL1. ...
Question 6: You have an Azure Data Factory pipeline that is triggered ho...
Question 7: Note: This question is part of a series of questions that pr...
Question 8: You have an Azure subscription that contains an Azure SQL da...
Question 9: You have an Azure Databricks resource. You need to log actio...
Question 10: You have an Azure SQL database named sqldb1. You need to min...
Question 11: You have an Azure Data Lake Storage Gen2 account named accou...
Question 12: You have an Azure SQL database named db1 on a server named s...
Question 13: From a website analytics system, you receive data extracts a...
Question 14: You have a Microsoft SQL Server 2017 server. You need to mig...
Question 15: You plan to deploy two instances of SQL Server on Azure virt...
Question 16: What should you use to migrate the PostgreSQL database?...
Question 17: You need to design a data retention solution for the Twitter...
Question 18: You are provisioning an Azure SQL database in the Azure port...
Question 19: You plan to perform batch processing in Azure Databricks onc...
Question 20: You have an Azure subscription. You need to deploy an Instan...
Question 21: You have an Azure SQL database. You need to implement a disa...
Question 22: You have a database on a SQL Server on Azure Virtual Machine...
Question 23: Note: This question is part of a series of questions that pr...
Question 24: You plan to move two 100-GB databases to Azure. You need to ...
Question 25: You manage 100 Azure SQL managed instances located across 10...
Question 26: You have an Azure SQL managed instance. You need to enable S...
Question 27: You have an Azure SQL Database managed instance. The instanc...
Question 28: You have an Azure Data Factory pipeline that performs an inc...
Question 29: You have an Azure Databricks workspace named workspace1 in t...
Question 30: You have an Azure Stream Analytics job. You need to ensure t...
Question 31: You have an Azure subscription that contains an instance of ...
Question 32: You plan to deploy two instances of SQL Server on Azure virt...
Question 33: You have An Azure SQL managed instance. You need to configur...
Question 34: You have a single availability set that contains two SQL Ser...
Question 35: You have an Azure subscription that uses a domain named cont...
Question 36: You have an Azure SQL database named sqldb1. You need to min...
Question 37: You have an Azure subscription that contains the resources s...
Question 38: You are building a database in an Azure Synapse Analytics se...
Question 39: You are designing a dimension table in an Azure Synapse Anal...
Question 40: You have an Azure subscription that contains two Azure SQL m...
Question 41: You plan to create a table in an Azure Synapse Analytics ded...
Question 42: You are designing a star schema for a dataset that contains ...
Question 43: You have 40 Azure SQL databases, each for a different custom...
Question 44: You have a SQL pool in Azure Synapse that contains a table n...
Question 45: You have the following Azure Resource Manager template. (Exh...
Question 46: You have an Azure data factory that has two pipelines named ...
Question 47: You have an Azure subscription. You plan to deploy a new Azu...
Question 48: You have an Azure SQL database named DB1 that contains a tab...
Question 49: You receive numerous alerts from Azure Monitor for an Azure ...
Question 50: You have an Azure subscription that is linked to a hybrid Az...
Question 51: You have a new Azure SQL database. The database contains a c...
Question 52: Which audit log destination should you use to meet the monit...
Question 53: You have 20 Azure SQL databases provisioned by using the vCo...
Question 54: You have SQL Server 2019 or an Azure virtual machine that ru...
Question 55: You have the following Transact-SQL query. (Exhibit) Which c...
Question 56: You have a Microsoft SQL Server 2017 server that hosts five ...
Question 57: You have an Azure SQL database named DB1. The automatic tuni...
Question 58: You have SQL Server on an Azure virtual machine that contain...
Question 59: You have an Azure subscription that contains 50 instances of...
Question 60: You have an Azure SQL Database managed instance named sqldbm...
Question 61: You have SQL Server 2019 on an Azure virtual machine that ru...
Question 62: You create all of the tables and views for ResearchDB1. You ...
Question 63: You have an Azure SQL database named DB1. You need to ensure...
Question 64: You have an on-premises Microsoft SQL Server 2019 instance n...
Question 65: You have an Azure SQL database. You need to identify whether...
Question 66: You have an Azure subscription that contains an Azure SQL da...
Question 67: You have an Azure subscription that contains a logical SQL s...
Question 68: You have an Azure subscription that contains the following r...
Question 69: You have an Azure SQL database named DB1. You need to displa...
Question 70: A data engineer creates a table to store employee informatio...
Question 71: You are building an Azure virtual machine. You allocate two ...
Question 72: You have two on-premises servers that run Windows Server 201...
Question 73: You have an Azure subscription that contains an Azure SQL da...
Question 74: You have an Azure SQL database named db1 on a server named s...
Question 75: You have a SQL Server on Azure Virtual Machines instance tha...
Question 76: You are building an Azure Stream Analytics job to retrieve g...
Question 77: You have an Azure SQL database. You discover that the plan c...
Question 78: You have an Azure subscription. Vou need to deploy two insta...
Question 79: You have a 50-TB Microsoft SQL Server database named DB1. Yo...
Question 80: You are building a database backup solution for a SQL Server...
Question 81: You have a SQL Server on Azure Virtual Machines instance nam...
Question 82: You have an Azure SQL database that contains a table named C...
Question 83: You deploy a database to an Azure SQL Database managed insta...
Question 84: You are planning a solution that will use Azure SQL Database...
Question 85: You are designing a streaming data solution that will ingest...
Question 86: You need to implement the surrogate key for the retail store...
Question 87: Your on-premises network contains a Microsoft SQL Server 201...
Question 88: You have an Azure Active Directory (Azure AD) tenant named c...
Question 89: You have an Azure SQL database. The database contains a tabl...
Question 90: You have an Azure SQL database named DB1. You need to encryp...
Question 91: You have 50 Azure SQL databases. You need to notify the data...
Question 92: You have an Azure SQL database named db1 that contains an Az...
Question 93: You are designing an enterprise data warehouse in Azure Syna...
Question 94: You have an Azure SQL Database elastic pool that contains 10...
Question 95: You have an Azure subscription that contains the resources s...
Question 96: You have an Azure subscription that contains an instance of ...
Question 97: You have an Azure SQL database named SOL1. You need to imple...
Question 98: You have an Azure SQL database. You are reviewing a slow per...
Question 99: You are planning disaster recovery for the failover group of...
Question 100: You have an Azure SQL database that contains a table named f...
Question 101: You plan to move two 100-GB databases to Azure. You need to ...
Question 102: You have an Azure subscription that contains an Azure SQL ma...
Question 103: You have an Azure key vault named Vault1 and a SQL Server on...
Question 104: You have an Azure virtual machine named VM1 on a virtual net...
Question 105: You are designing a security model for an Azure Synapse Anal...
Question 106: You have an instance of SQL Server on Azure Virtual Machines...
Question 107: You have an Azure AD tenant and a logical Microsoft SQL serv...
Question 108: You create a new Azure SQL managed instance named SQL1 and e...
Question 109: You have an Azure subscription that is linked to an Azure AD...
Question 110: You have an instance of SQL Server on Azure Virtual Machine ...
Question 111: Note: This question is part of a series of questions that pr...
Question 112: You have an Azure subscription. You need to deploy a logical...
Question 113: You have a new Azure SQL database named DB1 on an Azure SQL ...
Question 114: Note: This question is part of a series of questions that pr...
Question 115: You have a resource group named App1Dev that contains an Azu...
Question 116: You configure backups for an Azure SQL database as shown in ...
Question 117: You are performing exploratory analysis of bus fare data in ...
Question 118: You have an Azure SQL database named DB1. You run a query wh...
Question 119: You have an Azure subscription. You plan to deploy an Azure ...
Question 120: You have an Azure SQL database named DB 1 in the General Pur...
Question 121: You have a Microsoft SQL Server 2019 instance in an on-premi...
Question 122: You have an Azure Data Factory instance named ADF1 and two A...
Question 123: You have a version-8.0 Azure Database for MySQL database. Yo...
Question 124: You are creating a managed data warehouse solution on Micros...
Question 125: You have an Azure SQL managed instance. You need to gather t...
Question 126: You have an Azure SQL database. You have a query and the ass...
Question 127: You have an Azure subscription that contains the resources s...
Question 128: You have a SQL Server on Azure Virtual Machines instance tha...
Question 129: Note: This question is part of a series of questions that pr...
Question 130: You have an Azure subscription that contains an instance of ...
Question 131: You have an Azure SQL Database instance named DatabaseA on a...
Question 132: You have an Azure SQL database named DB1 in the General Purp...
Question 133: You have an Azure subscription that contains two instances o...
Question 134: You have a SQL Server on Azure Virtual Machines instance nam...
Question 135: You have an Azure subscription that contains a logical SQL s...
Question 136: You have an Azure subscription that contains a storage accou...
Question 137: You have an on-premises Microsoft SQL Server 2016 instance t...
Question 138: Note: This question is part of a series of questions that pr...
Question 139: You need to recommend a solution to ensure that the customer...
Question 140: You have an instance of SQL Server on Azure Virtual Machines...
Question 141: You have an Azure subscription that contains an Azure Data F...
Question 142: You have an Azure SQL managed instance named SQLMI1 that hos...
Question 143: You have an Azure subscription that contains the resources s...
Question 144: You have an Azure Data Lake Storage Gen2 container. Data is ...
Question 145: You Save an Azure SCX database named DB1. You need to query ...
Question 146: You are developing an application that uses Azure Data Lake ...
Question 147: You have an Azure subscription that contains the resources s...