<< Prev Question Next Question >>

Question 61/87

You have an Azure subscription.
You plan to deploy an Azure SQL database by using an Azure Resource Manager template.
How should you complete the template? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

LEAVE A REPLY

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

Question List (87q)
Question 1: You configure version control for an Azure Data Factory inst...
Question 2: Which counter should you monitor for real-time processing to...
Question 3: You have an Azure SQL database that contains a table named C...
Question 4: You have an Azure Data Factory that contains 10 pipelines. Y...
Question 5: You have a SQL Server on Azure Virtual Machines instance tha...
Question 6: You have four Azure subscriptions. Each subscription contain...
Question 7: You have an Azure SQL database named DB1. DB1 contains a tab...
Question 8: You are designing an enterprise data warehouse in Azure Syna...
Question 9: What should you implement to meet the disaster recovery requ...
Question 10: You need to implement the monitoring of SalesSQLDb1. The sol...
Question 11: You have an Azure SQL database. You have a query and the ass...
Question 12: You have an Azure SQL database named db1 on a server named s...
Question 13: You have SQL Server on an Azure virtual machine that contain...
Question 14: You have an Azure subscription that contains an Azure Data F...
Question 15: You have an Azure SQL database. You discover that the plan c...
Question 16: You are monitoring an Azure Stream Analytics job. You discov...
Question 17: You have an Azure SQL database named DB1. You have a table n...
Question 18: You have an Azure SQL Database managed instance named SQLMI1...
Question 19: You have a on-premises Microsoft SQL Server named SQL1 that ...
Question 20: You need to implement a solution to notify the administrator...
Question 21: You have a new Azure SQL database named DB1 on an Azure SQL ...
Question 22: What should you use to migrate the PostgreSQL database?...
Question 23: Your company uses Azure Stream Analytics to monitor devices....
Question 24: You need to migrate an on-premises Microsoft SQL Server data...
Question 25: You have a SQL pool in Azure Synapse that contains a table n...
Question 26: Note: This question is part of a series of questions that pr...
Question 27: You have SQL Server on an Azure virtual machine. You review ...
Question 28: Note: This question is part of a series of questions that pr...
Question 29: You are building a database backup solution for a SQL Server...
Question 30: You have a Microsoft SQL Server 2019 instance in an on-premi...
Question 31: You have an Azure Synapse Analytics dedicated SQL pool. You ...
Question 32: You have a Microsoft SQL Server 2019 database named DB1 that...
Question 33: You have an Azure SQL database named DB1. You run a query wh...
Question 34: You have an Azure SQL database named db1 that contains an Az...
Question 35: You have an Azure SQL database named DB1. The automatic tuni...
Question 36: You plan to move two 100-GB databases to Azure. You need to ...
Question 37: You have a data warehouse in Azure Synapse Analytics. You ne...
Question 38: You have an Azure SQL database named db1. You need to retrie...
Question 39: You have an Azure Data Factory pipeline that is triggered ho...
Question 40: You have 40 Azure SQL databases, each for a different custom...
Question 41: You have an Azure Data Factory pipeline that performs an inc...
Question 42: You have an Azure subscription that contains an Azure SQL ma...
Question 43: You have the following Transact-SQL query. (Exhibit) Which c...
Question 44: Your on-premises network contains a server that hosts a 60-T...
Question 45: You are designing a star schema for a dataset that contains ...
Question 46: You have an Azure SQL database named DB3. You need to provid...
Question 47: You have an instance of SQL Server on Azure Virtual Machine ...
Question 48: Note: This question is part of a series of questions that pr...
Question 49: You need to recommend a solution to ensure that the customer...
Question 50: You have a new Azure subscription. You create an Azure SQL D...
Question 51: You plan to create a table in an Azure Synapse Analytics ded...
Question 52: You need to recommend a configuration for ManufacturingSQLDb...
Question 53: You have SQL Server on an Azure virtual machine that contain...
Question 54: You have a database on a SQL Server on Azure Virtual Machine...
Question 55: You create all of the tables and views for ResearchDB1. You ...
Question 56: You have an Azure virtual machine named VM1 on a virtual net...
Question 57: You plan to build a structured streaming solution in Azure D...
Question 58: You deploy a database to an Azure SQL Database managed insta...
Question 59: You have an Azure SQL managed instance named MI1. You need t...
Question 60: You have an Azure Stream Analytics job. You need to ensure t...
Question 61: You have an Azure subscription. You plan to deploy an Azure ...
Question 62: You need to provide an implementation plan to configure data...
Question 63: You have SQL Server on an Azure virtual machine that contain...
Question 64: You have an Azure subscription that contains an Azure SQL da...
Question 65: A company plans to use Apache Spark analytics to analyze int...
Question 66: You need to design a data retention solution for the Twitter...
Question 67: You have an Azure SQL database named DBI that contains a non...
Question 68: You have an Azure Active Directory (Azure AD) tenant named c...
Question 69: You need to design an analytical storage solution for the tr...
Question 70: You create a new Azure SQL managed instance named SQL1 and e...
Question 71: You have an Azure subscription that contains an Azure SQL da...
Question 72: A data engineer creates a table to store employee informatio...
Question 73: You have SQL Server on an Azure virtual machine that contain...
Question 74: You are creating a managed data warehouse solution on Micros...
Question 75: You have an Azure subscription that contains an Azure SQL da...
Question 76: You have an Azure SQL database named DB1 that contains a pri...
Question 77: You are evaluating the role assignments. For each of the fol...
Question 78: You have an Azure SQL database. Users report that the execut...
Question 79: You have an Azure Synapse Analytics dedicated SQL pool named...
Question 80: You have a version-8.0 Azure Database for MySQL database. Yo...
Question 81: Note: This question is part of a series of questions that pr...
Question 82: You are creating a new notebook in Azure Databricks that wil...
Question 83: You have an Azure SQL managed instance named SQL1 and two Az...
Question 84: You have an Always On availability group deployed to Azure v...
Question 85: You plan to perform batch processing in Azure Databricks onc...
Question 86: Note: This question is part of a series of questions that pr...
Question 87: You have SQL Server on an Azure virtual machine. You need to...