[Jul 04, 2025] Microsoft DP-300 Exam Dumps Files, Q1/163: You have an Azure subscription that contains two instances of SQL Server on Azure Virtual Machines named

Join the discussion

Question 1/163

You have an Azure subscription that contains two instances of SQL Server on Azure Virtual Machines named VM1 and VM2. Both instances run Microsoft SQL Server 2019 CU8. You need to deploy a failover cluster instance (FCI) to VM1 and VM2. The solution must eliminate the need for the following:
* A distributed network name (DNN)
* A load balancer
What should you do?

A. Deploy VM1 and VM2 to a single proximity placement group.

B. Deploy VM1 and VM2 to different proximity placement groups in the same Azure region.

C. Connect VM1 and VM2 to different subnets on a single virtual network.

D. Connect VM1 and VM2 to a single subnet.

Add Comments

Other Question (163q): Q1. You have an Azure subscription that contains two instances of SQL Server on Azure Virtual ...; Q2. You have an Azure AD tenant and a logical Microsoft SQL server named SQL1 that hosts sever...; Q3. You configure version control for an Azure Data Factory instance as shown in the following...; Q4. You create all of the tables and views for ResearchDB1. You need to implement security for...; Q5. You need to identify the event_flle target for monitonng DB3 after the migration to Azure ...; Q6. You are evaluating the role assignments. For each of the following statements, select Yes ...; Q7. You have an instance of SQL Server on Azure Virtual Machines named VM1. You need to implem...; Q8. You need to recommend an authentication solution for App1 access to DB1 and DB2 after thei...; Q9. Note: This question is part of a series of questions that present the same scenario. Each ...; Q10. You have An Azure SQL managed instance. You need to configure the SQL Server Agent service...; Q11. A data engineer creates a table to store employee information for a new application. All e...; Q12. You need to recommend a process to automate the management of DB3. The solution must meet ...; Q13. You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound tra...; Q14. You have an Azure SQL Database instance named DatabaseA on a server named Server1. You pla...; Q15. You create a new Azure SQL managed instance named SQL1 and enable Database Mail extended s...; Q16. You have an Azure subscription that contains an Azure SQL database named DB1. You need to ...; Q17. You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound tra...; Q18. You have an Azure SQL database named DB1. DB1 contains a table that has a column named Col...; Q19. You have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The table ...; Q20. You have an Azure SQL managed instance named MI1. You need to implement automatic tuning f...; Q21. You have an Azure SQL database named DB1. You need to display the estimated execution plan...; Q22. You have an Azure subscription that uses a domain named contoso.com. You have two Azure VM...; Q23. You have an Azure subscription. You need to deploy a new Azure SQL database by using Azure...; Q24. Note: This question is part of a series of questions that present the same scenario. Each ...; Q25. You have an Azure virtual machine named Server1 that runs Windows Server 2022. Server! con...; Q26. You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and an Azure Data Lake ...; Q27. You have an Azure subscription that contains a group named Group1 and an Azure SQL managed...; Q28. You have the following Transact-SQL query. (Exhibit) Which column returned by the query re...; Q29. You need to recommend which service and target endpoint to use when migrating the database...; Q30. You have an Azure subscription that contains the resources shown in the following table. (...; Q31. You have an Azure subscription that contains a logical SQL server. The server hosts two da...; Q32. Note: This question is part of a series of questions that present the same scenario. Each ...; Q33. Note: This question is part of a series of questions that present the same scenario. Each ...; Q34. You have an Azure SQL database named DB3. You need to provide a user named DevUser with th...; Q35. Note: This question is part of a series of questions that present the same scenario. Each ...; Q36. Your company analyzes images from security cameras and sends alerts to security teams that...; Q37. You have SQL Server on an Azure virtual machine. You need to use Policy-Based Management i...; Q38. You Save an Azure SCX database named DB1. You need to query the fragmentation information ...; Q39. You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 is...; Q40. You have an Azure Databricks workspace named workspace1 in the Standard pricing tier. Work...; Q41. You are designing an anomaly detection solution for streaming data from an Azure IoT hub. ...; Q42. Which windowing function should you use to perform the streaming aggregation of the sales ...; Q43. You have an Azure SQL database named sqldb1. You need to minimize the possibility of Query...; Q44. You have an Azure subscription that contains 50 instances of SQL Server on Azure Virtual M...; Q45. You have 40 Azure SQL databases, each for a different customer. All the databases reside o...; Q46. You have a new Azure SQL database named DB1 on an Azure SQL server named AzSQL1. The only ...; Q47. You have an on-premises Microsoft SQL Server 2016 instance that hosts a database named db1...; Q48. You have an Azure SQL managed instance that hosts multiple databases. You need to configur...; Q49. You have an Azure SQL database. You run the following PowerShell script. (Exhibit) For eac...; Q50. You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Ma...; Q51. You have an Azure SQL database named DB1 that contains a private certificate named Sales. ...; Q52. You have an Azure subscription. You need to deploy a logical SQL server by using PowerShel...; Q53. You have an Azure SQL database named DB1. DB1 has a table named Table1 that contains the f...; Q54. You need to recommend a configuration for ManufacturingSQLDb1 after the migration to Azure...; Q55. You have an on-premises Microsoft SQL Server 2019 database named SQL1 that uses merge repl...; Q56. You have an Azure SQL database named DB1. A user named User 1 has an Azure AD account. You...; Q57. You have a Microsoft SQL Server 2017 server that hosts five databases. You Plan to migrate...; Q58. You configure a long-term retention policy for an Azure SQL database as shown in the exhib...; Q59. Task 1 In an Azure SQL database named db1, you need to enable page compression on the PK_S...; Q60. You have an Azure subscription. You plan to deploy an instance of SQL Sevier on Azure Virt...; Q61. You have an Azure subscription that contains an Azure SQL database named db1. You need to ...; Q62. You have an on-premises datacenter that contains a 2-TB Microsoft SQL Server 2019 database...; Q63. Task 7 You plan to create an automation runbook that will create database users in db1 fro...; Q64. You have an Azure SQL managed instance named SQL1 and two Azure web apps named App1 and Ap...; Q65. You have an Azure Data Factory pipeline that performs an incremental load of source data t...; Q66. You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Ma...; Q67. You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 co...; Q68. You have an Azure SQL database named DB1 that contains a table named Orders. The Orders ta...; Q69. Note: This question is part of a series of questions that present the same scenario. Each ...; Q70. You need to recommend the appropriate purchasing model and deployment option for the 30 ne...; Q71. You have an Azure subscription that contains an Azure Data Factory version 2 (V2) data fac...; Q72. You have an Azure SQL database named that contains a table named Table1. You run a query t...; Q73. Note: This question is part of a series of questions that present the same scenario. Each ...; Q74. What should you use to migrate the PostgreSQL database?...; Q75. You have an Azure SQL database. You need to identify whether a delayed query execution is ...; Q76. Your on-premises network contains a Microsoft SQL Server 2016 server that hosts a database...; Q77. You plan to deploy an app that includes an Azure SQL database and an Azure web app. The ap...; Q78. You have an Azure Active Directory (Azure AD) tenant named contoso.com that contains a use...; Q79. You have a data warehouse in Azure Synapse Analytics. You need to ensure that the data in ...; Q80. You have an Azure SQL database named DB1. You need to encrypt DB1. The solution must meet ...; Q81. You need to implement authentication for ResearchDB1. The solution must meet the security ...; Q82. Which counter should you monitor for real-time processing to meet the technical requiremen...; Q83. You have an Azure Stream Analytics job. You need to ensure that the job has enough streami...; Q84. You have two Azure virtual machines named VM1 and VM2 that run Windows Server 2019. VM1 an...; Q85. You have four Azure subscriptions. Each subscription contains multiple Azure SQL databases...; Q86. You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1...; Q87. You have an Azure SQL managed instance. You need to enable SQL Agent Job email notificatio...; Q88. You receive numerous alerts from Azure Monitor for an Azure SQL database. You need to redu...; Q89. You have a SQL Server on Azure Virtual Machines instance named SQLVM1 that was deployed by...; Q90. You have an instance of SQL Server on Azure Virtual Machine named SQL1. You need to monito...; Q91. Note: This question is part of a series of questions that present the same scenario. Each ...; Q92. You need to identify the cause of the performance issues on SalesSQLDb1. Which two dynamic...; Q93. You plan to create a table in an Azure Synapse Analytics dedicated SQL pool. Data in the t...; Q94. You have an Azure virtual machine based on a custom image named VM1. VM1 hosts an instance...; Q95. You are creating a managed data warehouse solution on Microsoft Azure. You must use PolyBa...; Q96. You have an Azure virtual machine named VM1 that runs Windows Server 2022 and hosts a Micr...; Q97. Task 9 You need to generate an email alert to [email protected] when CPU percentage utiliz...; Q98. Task 5 You need to configure a disaster recovery solution for db1. When a failover occurs,...; Q99. You have an Azure SQL database named SOL1. You need to implement a disaster recovery solut...; Q100. You need to design an analytical storage solution for the transactional data. The solution...; Q101. You have an Azure SQL database. You identify a long running query. You need to identify wh...; Q102. You have an Azure SQL database named DB 1 in the General Purpose service tier. You need to...; Q103. You configure backups for an Azure SQL database as shown in the following exhibit. (Exhibi...; Q104. Note: This question is part of a series of questions that present the same scenario. Each ...; Q105. You have an Azure Data Lake Storage Gen2 container. Data is ingested into the container, a...; Q106. You are provisioning an Azure SQL database in the Azure portal as shown in the following e...; Q107. Task 6 You need to ensure that any enhancements made to the Query Optimizer through patche...; Q108. You have a SQL Server on Azure Virtual Machines instance that hosts a database named Db1. ...; Q109. Note: This question is part of a series of questions that present the same scenario. Each ...; Q110. You have an Azure SQL Database elastic pool that contains 10 databases. You receive the fo...; Q111. You plan to deploy two instances of SQL Server on Azure virtual machines in a highly avail...; Q112. You are monitoring an Azure Stream Analytics job. You discover that the Backlogged input E...; Q113. You have an on-premises Microsoft SQL Server 2019 instance named SQL1 that hosts a databas...; Q114. You have an Azure SQL managed instance named SQLMI1 that hosts 10 databases. You need to i...; Q115. You are building a database in an Azure Synapse Analytics serverless SQL pool. You have da...; Q116. You are performing exploratory analysis of bus fare data in an Azure Data Lake Storage Gen...; Q117. Note: This question is part of a series of questions that present the same scenario. Each ...; Q118. You have an Azure subscription that contains a resource group named RG1. RG1 contains an i...; Q119. You have an Azure data factory that has two pipelines named PipelineA and PipelineB. Pipel...; Q120. You have SQL Server 2019 on an Azure virtual machine that contains an SSISDB database. A r...; Q121. What should you implement to meet the disaster recovery requirements for the PaaS solution...; Q122. You are building a database backup solution for a SQL Server database hosted on an Azure v...; Q123. You have the following Azure Resource Manager template. (Exhibit) For each of the followin...; Q124. Task 4 You need to enable change data capture (CDC) for db1....; Q125. You need to implement statistics maintenance for SalesSQLDb1. The solution must meet the t...; Q126. You have a Microsoft SQL Server 2019 database named DB1 and an Azure SQL managed instance ...; Q127. You have an Azure subscription. You plan to deploy an instance of SQL Server on Azure Virt...; Q128. You have an Azure SQL database. You are reviewing a slow performing query as shown in the ...; Q129. You have an Azure subscription. You plan to deploy a new Azure virtual machine that will h...; Q130. You have an Azure subscription that contains an Azure SQL database. The database contains ...; Q131. You have an Azure subscription that contains an Azure SQL managed instance named SQLMi1 an...; Q132. You have an Azure subscription. You need to deploy an Azure SQL resource that will support...; Q133. You have an instance of SQL Server on Azure Virtual Machines. You need to ensure that a us...; Q134. You are designing an enterprise data warehouse in Azure Synapse Analytics that will contai...; Q135. You have an Azure SQL managed instance named Server1 and an Azure Blob Storage account nam...; Q136. You have 50 Azure SQL databases. You need to notify the database owner when the database s...; Q137. You need to recommend a solution to meet the security requirements and the business requir...; Q138. You have an Azure SQL database. Users report that the executions of a stored procedure are...; Q139. You have an Azure subscription that contains an instance of SQL Server on an Azure virtual...; Q140. You are building an Azure virtual machine. You allocate two 1-TiB, P30 premium storage dis...; Q141. You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance c...; Q142. You have an Azure SQL database. The database contains a table that uses a columnstore inde...; Q143. You need to migrate an on-premises Microsoft SQL Server database to Azure SQL Database. Th...; Q144. You have an Azure SQL database that contains a table named factSales. FactSales contains t...; Q145. You need to implement the surrogate key for the retail store table. The solution must meet...; Q146. You have an Azure subscription. You need to deploy an Instance of SQL Server on Azure Virt...; Q147. You are evaluating the business goals. Which feature should you use to provide customers w...; Q148. You have an Azure SQL database named DB1 that contains a table named Table 1. You run a qu...; Q149. You have an Azure Synapse Analytics dedicated SQL pool. You run PDW_SHOWSPACEUSED('dbo.Fac...; Q150. You have a Microsoft SQL Server 2017 server. You need to migrate the server to Azure. The ...; Q151. You have an instance of SQL Server on Azure Virtual Machines named SQL1. SQL1 contains a d...; Q152. You plan to move two 100-GB databases to Azure. You need to dynamically scale resources co...; Q153. You have an Azure subscription. Vou need to deploy two instances of SQL Server on Azure vi...; Q154. You need to implement the monitoring of SalesSQLDb1. The solution must meet the technical ...; Q155. You have a on-premises Microsoft SQL Server named SQL1 that hosts five databases. You need...; Q156. You have an on-premises multi-tier application named App1 that includes a web tier, an app...; Q157. Note: This question is part of a series of questions that present the same scenario. Each ...; Q158. You have an on-premises datacenter that contains a 14-TB Microsoft SQL Server database. Yo...; Q159. You are designing a date dimension table in an Azure Synapse Analytics dedicated SQL pool....; Q160. You are designing a streaming data solution that will ingest variable volumes of data. You...; Q161. You have an Azure subscription. You need to deploy an Azure SQL managed instance by using ...; Q162. You have a Microsoft SQL Server database named DB1 that contains a table named Table1. The...; Q163. You have an Azure subscription that contains the resources shown in the following table. (...

Join the discussion

Question 1/163

Add Comments

Download PDF File