<< Prev Question Next Question >>

Question 11/72

You have SQL Server on an Azure virtual machine named SQL1.
SQL1 has an agent job to back up all databases.
You add a user named dbadmin1 as a SQL Server Agent operator.
You need to ensure that dbadmin1 receives an email alert if a job fails.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

LEAVE A REPLY

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

Question List (72q)
Question 1: You have two Azure virtual machines named VM1 and VM2 that r...
Question 2: You have an Azure SQL database named db1. You need to retrie...
Question 3: Note: This question is part of a series of questions that pr...
Question 4: You need to apply 20 built-in Azure Policy definitions to al...
Question 5: You have a on-premises Microsoft SQL Server named SQL1 that ...
Question 6: You have a 50-TB Microsoft SQL Server database named DB1. Yo...
Question 7: You have an Azure SQL managed instance. You need to enable S...
Question 8: You have a Microsoft SQL Server database named DB1 that cont...
Question 9: Note: This question is part of a series of questions that pr...
Question 10: You have an Azure SQL database named DB1. The automatic tuni...
Question 11: You have SQL Server on an Azure virtual machine named SQL1. ...
Question 12: You have a resource group named App1Dev that contains an Azu...
Question 13: Note: This question is part of a series of questions that pr...
Question 14: Note: This question is part of a series of questions that pr...
Question 15: You have an Azure subscription that contains an Azure SQL da...
Question 16: Note: This question is part of a series of questions that pr...
Question 17: You have a data warehouse in Azure Synapse Analytics. You ne...
Question 18: You have an Azure Synapse Analytics Apache Spark pool named ...
Question 19: You have an instance of SQL Server on Azure Virtual Machine ...
Question 20: You are building a database in an Azure Synapse Analytics se...
Question 21: You have an Azure SQL Database managed instance named SQLMI1...
Question 22: You have an Azure SQL managed instance named MI1. You need t...
Question 23: You have SQL Server on an Azure virtual machine that contain...
Question 24: From a website analytics system, you receive data extracts a...
Question 25: You have an Azure subscription that contains an Azure Data F...
Question 26: You have the following Transact-SQL query. (Exhibit) Which c...
Question 27: You have an Azure SQL database. You run the following PowerS...
Question 28: Note: This question is part of a series of questions that pr...
Question 29: Note: This question is part of a series of questions that pr...
Question 30: You are designing a star schema for a dataset that contains ...
Question 31: What should you implement to meet the disaster recovery requ...
Question 32: You have an on-premises app named App1 that stores data in a...
Question 33: You have a SQL Server on Azure Virtual Machines instance nam...
Question 34: Which windowing function should you use to perform the strea...
Question 35: You have a version-8.0 Azure Database for MySQL database. Yo...
Question 36: You have an Azure SQL database named DB1. DB1 contains a tab...
Question 37: You have an on-premises Microsoft SQL Server 2019 server tha...
Question 38: You have a database on a SQL Server on Azure Virtual Machine...
Question 39: You are developing an application that uses Azure Data Lake ...
Question 40: You have an Azure SQL database that contains a table named E...
Question 41: You are monitoring an Azure Stream Analytics job. You discov...
Question 42: Based on the PaaS prototype, which Azure SQL Database comput...
Question 43: You have an Azure virtual machine based on a custom image na...
Question 44: Note: This question is part of a series of questions that pr...
Question 45: You need to trigger an Azure Data Factory pipeline when a fi...
Question 46: You have SQL Server on an Azure virtual machine that contain...
Question 47: You have an Azure subscription that is linked to a hybrid Az...
Question 48: You have an on-premises Microsoft SQL server that uses the F...
Question 49: You are designing a security model for an Azure Synapse Anal...
Question 50: You have an Azure SQL Database instance named DatabaseA on a...
Question 51: You have an Azure Data Factory instance named ADF1 and two A...
Question 52: You have SQL Server on an Azure virtual machine that contain...
Question 53: You have an Azure data solution that contains an enterprise ...
Question 54: You manage an enterprise data warehouse in Azure Synapse Ana...
Question 55: You have an Azure SQL database. You are reviewing a slow per...
Question 56: You need to design a data retention solution for the Twitter...
Question 57: You have an Azure SQL database named db1 on a server named s...
Question 58: You have an instance of SQL Server on Azure Virtual Machine ...
Question 59: You have an Azure subscription. You need to deploy an Azure ...
Question 60: You plan to perform batch processing in Azure Databricks onc...
Question 61: You are designing an enterprise data warehouse in Azure Syna...
Question 62: Which counter should you monitor for real-time processing to...
Question 63: You need to recommend an availability strategy for an Azure ...
Question 64: You create five Azure SQL Database instances on the same log...
Question 65: You have an Azure Data Lake Storage Gen2 container. Data is ...
Question 66: You need to design an analytical storage solution for the tr...
Question 67: You are creating a new notebook in Azure Databricks that wil...
Question 68: You are designing a streaming data solution that will ingest...
Question 69: You have SQL Server on Azure virtual machines in an availabi...
Question 70: You have an Azure subscription. You plan to deploy an Azure ...
Question 71: You have an Azure SQL Database server named sqlsrv1 that hos...
Question 72: You plan to create a table in an Azure Synapse Analytics ded...