<< Prev Question Next Question >>

Question 16/77

You need to recommend the appropriate purchasing model and deployment option for the 30 new databases. The solution must meet the technical requirements and the business requirements.
What should you recommend? 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 (77q)
Question 1: You have an Azure subscription that contains an Azure SQL da...
Question 2: You plan to build a structured streaming solution in Azure D...
Question 3: You have SQL Server on Azure virtual machines in an availabi...
Question 4: Note: This question is part of a series of questions that pr...
Question 5: You have two on-premises Microsoft SQL Server 2019 instances...
Question 6: You are designing a dimension table in an Azure Synapse Anal...
Question 7: You have an Azure Data Lake Storage Gen2 container. Data is ...
Question 8: You have an Azure SQL managed instance that hosts multiple d...
Question 9: You have an Azure SQL database. You have a query and the ass...
Question 10: Note: This question is part of a series of questions that pr...
Question 11: Your company uses Azure Stream Analytics to monitor devices....
Question 12: You have the following Azure Resource Manager template. (Exh...
Question 13: You have an Azure Synapse Analytics dedicated SQL pool named...
Question 14: You have an Azure Synapse Analytics dedicated SQL pool. You ...
Question 15: You have a data warehouse in Azure Synapse Analytics. You ne...
Question 16: You need to recommend the appropriate purchasing model and d...
Question 17: You have SQL Server on an Azure virtual machine. You review ...
Question 18: You have 40 Azure SQL databases, each for a different custom...
Question 19: You have an Azure Data Factory pipeline that is triggered ho...
Question 20: You have an Azure virtual machine based on a custom image na...
Question 21: You have a new Azure SQL database named DB1 on an Azure SQL ...
Question 22: You have an on-premises multi-tier application named App1 th...
Question 23: Your on-premises network contains a server that hosts a 60-T...
Question 24: Note: This question is part of a series of questions that pr...
Question 25: You have a SQL Server on Azure Virtual Machines instance tha...
Question 26: You have an Azure subscription that uses a domain named cont...
Question 27: You have SQL Server on an Azure virtual machine that contain...
Question 28: You have an Azure subscription that contains the resources s...
Question 29: You plan to create a table in an Azure Synapse Analytics ded...
Question 30: A company plans to use Apache Spark analytics to analyze int...
Question 31: You have an on-premises Microsoft SQL server that uses the F...
Question 32: You are monitoring an Azure Stream Analytics job. You discov...
Question 33: You have an Azure subscription that contains an Azure SQL ma...
Question 34: You have an Azure SQL managed instance named SQLMI1 that hos...
Question 35: You are planning the migration of the SERVER1 databases. The...
Question 36: You create a new Azure SQL managed instance named SQL1 and e...
Question 37: You have a new Azure subscription. You create an Azure SQL D...
Question 38: You have an Azure SQL managed instance named SQLMI1 that has...
Question 39: You need to recommend an availability strategy for an Azure ...
Question 40: You have an Azure SQL managed instance. You need to enable S...
Question 41: You have two on-premises servers that run Windows Server 201...
Question 42: You have an Azure subscription that contains the resources s...
Question 43: You have an Azure Data Factory instance named ADF1 and two A...
Question 44: You need to implement the surrogate key for the retail store...
Question 45: You need to design a data retention solution for the Twitter...
Question 46: You need to use an Azure Resource Manager ARM) template to d...
Question 47: You need to recommend a configuration for ManufacturingSQLDb...
Question 48: You need to design an analytical storage solution for the tr...
Question 49: You need to trigger an Azure Data Factory pipeline when a fi...
Question 50: You have an Azure SQL database named db1 that contains an Az...
Question 51: You have an Azure SQL database named DB1 that contains a tab...
Question 52: You have an Azure SQL database. Users report that the execut...
Question 53: You have two Azure virtual machines named VM1 and VM2 that r...
Question 54: You have an Azure SQL managed instance. You need to restore ...
Question 55: You are planning disaster recovery for the failover group of...
Question 56: You need to configure user authentication for the SERVER1 da...
Question 57: You are designing a streaming data solution that will ingest...
Question 58: You have SQL Server on an Azure virtual machine named SQL1. ...
Question 59: You are designing an enterprise data warehouse in Azure Syna...
Question 60: You have an Azure Stream Analytics job. You need to ensure t...
Question 61: You have a SQL Server on Azure Virtual Machines instance nam...
Question 62: What should you implement to meet the disaster recovery requ...
Question 63: You have an on-premises Microsoft SQL Server 2019 server tha...
Question 64: You have a new Azure SQL database. The database contains a c...
Question 65: You have an Azure SQL managed instance named SQL1 and two Az...
Question 66: You have SQL Server on an Azure virtual machine. You need to...
Question 67: You have an Azure virtual machine named VM1 on a virtual net...
Question 68: You have an Azure SQL logical server. You run the following ...
Question 69: You have a Microsoft SQL Server 2017 server. You need to mig...
Question 70: You are building a database in an Azure Synapse Analytics se...
Question 71: Note: This question is part of a series of questions that pr...
Question 72: You have an Azure SQL database named DB1. The automatic tuni...
Question 73: You configure version control for an Azure Data Factory inst...
Question 74: You have an Azure SQL Database server named sqlsrv1 that hos...
Question 75: You plan to deploy an app that includes an Azure SQL databas...
Question 76: You have SQL Server on an Azure virtual machine that contain...
Question 77: Which audit log destination should you use to meet the monit...