[Jul 10, 2024] Microsoft DP-300 Exam Dumps Files, Q1/273: You have 20 Azure SQL databases provisioned by using the vCore purchasing model. You plan to create an

Join the discussion

Question 1/273

You have 20 Azure SQL databases provisioned by using the vCore purchasing model.
You plan to create an Azure SQL Database elastic pool and add the 20 databases.
Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. total size of all the databases

B. geo-replication support

C. number of concurrently peaking databases * peak CPU utilization per database

D. maximum number of concurrent sessions for all the databases

E. total number of databases * average CPU utilization per database

Add Comments

Other Question (273q): Q1. You have 20 Azure SQL databases provisioned by using the vCore purchasing model. You plan ...; Q2. You have an Azure SQL Database instance named DatabaseA on a server named Server1. You pla...; Q3. You have a database named db1. The log for db1 contains the following entry. (Exhibit) You...; Q4. You have an on-premises Microsoft SQL Server 2016 server named Server1 that contains a dat...; Q5. You have an Azure SQL database named db1 that contains an Azure Active Directory (Azure AD...; Q6. You plan to migrate on-premises Microsoft SQL Server databases to Azure. You need to ident...; Q7. You create a new Azure SQL managed instance named SQL1 and enable Database Mail extended s...; Q8. You plan to develop a dataset named Purchases by using Azure Databricks. Purchases will co...; Q9. You have SQL Server on an Azure virtual machine. You review the query plan shown in the fo...; Q10. You create a new Azure SQL managed instance named SQL1 and enable Database Mail extended s...; Q11. You have an Azure SQL database. You run the following PowerShell script. (Exhibit) For eac...; Q12. You have an Azure SQL database named DB1. The automatic tuning options for DB1 are configu...; Q13. Note: This question is part of a series of questions that present the same scenario. Each ...; Q14. HOTSPOT You have an Azure SQL database named DB1 that contains two tables named Table1 and...; Q15. You have an on-premises Microsoft SQL Server 2016 instance that hosts a database named db1...; Q16. You have the following Azure Resource Manager template. (Exhibit) For each of the followin...; Q17. You have a resource group named App1Dev that contains an Azure SQL Database server named D...; Q18. You have an Azure subscription that contains the resources shown in the following table. (...; Q19. You have an Azure SQL managed instance named SQL1 and two Azure web apps named App1 and Ap...; Q20. You have an Azure SQL database named DB 1 in the General Purpose service tier. You need to...; Q21. You have an Azure SQL database named db1 on a server named server1. You use Query Performa...; Q22. You have an Azure subscription. You need to deploy an Azure SQL managed instance by using ...; Q23. You have a database on a SQL Server on Azure Virtual Machines instance. The current state ...; Q24. You have SQL Server on Azure virtual machines in an availability group. You have a databas...; Q25. You need to recommend the appropriate purchasing model and deployment option for the 30 ne...; Q26. You have an Azure SQL database named DB1. The automatic tuning options for DB1 are configu...; Q27. You have an Azure subscription that contains a logical SQL server. The server hosts two da...; Q28. You have an Azure subscription. You need to deploy an Azure SQL managed instance by using ...; Q29. You have an Azure data solution that contains an enterprise data warehouse in Azure Synaps...; Q30. You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and an Azure Data Lake ...; Q31. You have an Azure SQL database that contains a table named factSales. FactSales contains t...; Q32. You have an Azure subscription that contains an Azure SQL database. The database fails to ...; Q33. You have an Azure subscription that contains an Azure SQL database named SQLDb1. SQLDb1 co...; Q34. You configure a long-term retention policy for an Azure SQL database as shown in the exhib...; Q35. You have a new Azure SQL database named DB1 on an Azure SQL server named AzSQL1. The only ...; Q36. You need to design an analytical storage solution for the transactional dat a. The solutio...; Q37. You have an Azure subscription. You need to deploy an Azure SQL managed instance by using ...; Q38. You need to recommend a solution to ensure that the customers can create the database obje...; Q39. You have an Azure SQL database named DB1. You run a query while connected to DB1. You revi...; Q40. You have an Azure Databricks workspace named workspace1 in the Standard pricing tier. Work...; Q41. You are planning the migration of the SERVER1 databases. The solution must meet the busine...; Q42. You have a 50-TB Microsoft SQL Server database named DB1. You need to reduce the time it t...; Q43. You are planning the migration of the SERVER1 databases. The solution must meet the busine...; Q44. You have an Azure Synapse Analytics Apache Spark pool named Pool1. You plan to load JSON f...; Q45. You need to implement statistics maintenance for SalesSQLDb1. The solution must meet the t...; Q46. You create a new Azure SQL managed instance named SQL1 and enable Database Mail extended s...; Q47. Task 12 You need to configure high availability for dbl. The solution must tolerate the lo...; Q48. You have an Azure subscription that contains a server named Server1. Server1 hosts two Azu...; Q49. You have an Azure SQL database named DB1. DB1 contains a table that has a column named Col...; Q50. You have an Azure SQL database. You need to identify whether a delayed query execution is ...; Q51. You plan to migrate on-premises Microsoft SQL Server databases to Azure. You need to ident...; Q52. You have an Azure Active Directory (Azure AD) tenant named contoso.com that contains a use...; Q53. HOTSPOT You have an Azure SQL database named db1. You need to retrieve the resource usage ...; Q54. Your company analyzes images from security cameras and sends alerts to security teams that...; Q55. You have an Azure SQL database. You run the following PowerShell script. (Exhibit) For eac...; Q56. DRAG DROP You have a new Azure SQL database named DB1 on an Azure SQL server named AzSQL1....; Q57. You have an Azure subscription that contains a resource group named RG1. RG1 contains an i...; Q58. You have an Azure subscription that contains a group named Group1 and an Azure SQL managed...; Q59. You have 20 Azure SQL databases provisioned by using the vCore purchasing model. You plan ...; Q60. You configure a long-term retention policy for an Azure SQL database as shown in the exhib...; Q61. You have an Azure SQL managed instance named SQLMI1 that has Resource Governor enabled and...; Q62. You have an Azure SQL database named db1 that contains an Azure Active Directory (Azure AD...; Q63. You configure version control for an Azure Data Factory instance as shown in the following...; Q64. You have an Azure SQL database that contains a table named factSales. FactSales contains t...; Q65. You have an Azure subscription that contains a group named Group1 and an Azure SQL managed...; Q66. You have a SQL Server on Azure Virtual Machines instance that hosts a database named Db1. ...; Q67. You have an Azure SQL database. You run the following PowerShell script. (Exhibit) For eac...; Q68. You have an Azure subscription. You plan to migrate 10 on-premises Microsoft SQL Server in...; Q69. You have SQL Server on an Azure virtual machine that contains a database named DB1. The da...; Q70. You are performing exploratory analysis of bus fare data in an Azure Data Lake Storage Gen...; Q71. You have an Azure subscription that contains an Azure SQL database. The database fails to ...; Q72. You have an Azure Synapse Analytics Apache Spark pool named Pool1. You plan to load JSON f...; Q73. You have an Azure SQL database. You discover that the plan cache is full of compiled plans...; Q74. You are designing an enterprise data warehouse in Azure Synapse Analytics that will store ...; Q75. You have two instances of SQL Server on Azure virtual Machines named VM1 and VM2. VM1 host...; Q76. You have an Azure Data Factory that contains 10 pipelines. You need to label each pipeline...; Q77. You plan to create a table in an Azure Synapse Analytics dedicated SQL pool. Data in the t...; Q78. Your company uses Azure Stream Analytics to monitor devices. The company plans to double t...; Q79. You have an Azure SQL database named DB1. You run a query while connected to DB1. You revi...; Q80. You create a new Azure SQL managed instance named SQL1 and enable Database Mail extended s...; Q81. You have a resource group named App1Dev that contains an Azure SQL Database server named D...; Q82. You need to recommend a configuration for ManufacturingSQLDb1 after the migration to Azure...; Q83. You have an Azure SQL database. You need to implement a disaster recovery solution that me...; Q84. You have an Azure SQL database named DB1 that contains a private certificate named Sales. ...; Q85. You have a new Azure SQL database named DB1 on an Azure SQL server named AzSQL1. The only ...; Q86. You have an Azure SQL database named db1 on a server named server1. You use Query Performa...; Q87. You configure version control for an Azure Data Factory instance as shown in the following...; Q88. You plan to deploy an app that includes an Azure SQL database and an Azure web app. The ap...; Q89. You have an Azure subscription that contains a storage account named databasebackups. You ...; Q90. You are building a database backup solution for a SQL Server database hosted on an Azure v...; Q91. You have a database on a SQL Server on Azure Virtual Machines instance. The current state ...; Q92. You have SQL Server 2019 on an Azure virtual machine that contains an SSISDB database. A r...; Q93. You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance c...; Q94. You have an Azure SQL database named DB1. You need to ensure that DB1 will support automat...; Q95. You have an Azure virtual machine based on a custom image named VM1. VM1 hosts an instance...; Q96. You are building a database in an Azure Synapse Analytics serverless SQL pool. You have da...; Q97. DRAG DROP You need to apply 20 built-in Azure Policy definitions to all new and existing A...; Q98. You need to design an analytical storage solution for the transactional dat a. The solutio...; Q99. You plan to create a table in an Azure Synapse Analytics dedicated SQL pool. Data in the t...; Q100. You configure backups for an Azure SQL database as shown in the following exhibit. (Exhibi...; Q101. You have 10 Azure virtual machines that have SQL Server installed. You need to implement a...; Q102. You need to provide an implementation plan to configure data retention for ResearchDB1. Th...; Q103. You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1...; Q104. You have an Azure SQL database. You are reviewing a slow performing query as shown in the ...; Q105. Note: This question is part of a series of questions that present the same scenario. Each ...; Q106. You plan to migrate on-premises Microsoft SQL Server databases to Azure. You need to ident...; Q107. You have an Azure SQL database named DB1. DB1 contains a table that has a column named Col...; Q108. You have a new Azure SQL database named DB1 on an Azure SQL server named AzSQL1. The only ...; Q109. You have SQL Server on an Azure virtual machine that contains a database named DB1. The da...; Q110. You need to implement the monitoring of SalesSQLDb1. The solution must meet the technical ...; Q111. You need to apply 20 built-in Azure Policy definitions to all new and existing Azure SQL D...; Q112. You are provisioning an Azure SQL database in the Azure portal as shown in the following e...; Q113. You have an Azure SQL database named DB1. The automatic tuning options for DB1 are configu...; Q114. You need to design an analytical storage solution for the transactional dat a. The solutio...; Q115. You have an Azure Databricks workspace named workspace1 in the Standard pricing tier. Work...; Q116. You are designing an enterprise data warehouse in Azure Synapse Analytics that will store ...; Q117. You need to design an analytical storage solution for the transactional dat a. The solutio...; Q118. You have an Azure subscription. You plan to deploy an Azure SQL database by using an Azure...; Q119. You need to recommend the appropriate purchasing model and deployment option for the 30 ne...; Q120. You have an Azure subscription that is linked to a hybrid Azure Active Directory (Azure AD...; Q121. You plan to migrate on-premises Microsoft SQL Server databases to Azure. You need to ident...; Q122. You have an Azure SQL database named db1. You need to retrieve the resource usage of db1 f...; Q123. You have an Azure SQL database named DB 1 in the General Purpose service tier. You need to...; Q124. You need to configure user authentication for the SERVER1 databases. The solution must mee...; Q125. You have an Azure SQL Database instance named DatabaseA on a server named Server1. You pla...; Q126. Which audit log destination should you use to meet the monitoring requirements?...; Q127. You have an Azure subscription that contains the resources shown in the following table. (...; Q128. You have a SQL Server on Azure Virtual Machines instance that hosts a database named Db1. ...; Q129. You have an Azure subscription that contains an Azure SQL database. The database contains ...; Q130. You need to recommend an availability strategy for an Azure SQL database. The strategy mus...; Q131. You plan to create a table in an Azure Synapse Analytics dedicated SQL pool. Data in the t...; Q132. You have an Azure SQL database named that contains a table named Table1. You run a query t...; Q133. You have an Azure SQL database named that contains a table named Table1. You run a query t...; Q134. What should you implement to meet the disaster recovery requirements for the PaaS solution...; Q135. You have an Azure SQL Database instance named DatabaseA on a server named Server1. You pla...; Q136. You are building an Azure virtual machine. You allocate two 1-TiB, P30 premium storage dis...; Q137. You have an Azure SQL database named db1 on a server named server1. The Intelligent Insigh...; Q138. You have an Azure SQL database named DB1 that contains two tables named Table1 and Table2....; Q139. You have an Azure subscription that contains an Azure SQL managed instance, a database nam...; Q140. You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound tra...; Q141. You need to recommend the appropriate purchasing model and deployment option for the 30 ne...; Q142. You have the following Transact-SQL query. (Exhibit) Which column returned by the query re...; Q143. You plan to migrate on-premises Microsoft SQL Server databases to Azure. You need to ident...; Q144. You have an Azure SQL Database managed instance named sqldbmi1 that contains a database na...; Q145. You have an Azure SQL database. You have a query and the associated execution plan as show...; Q146. You have an on-premises Microsoft SQL Server 2016 server named Server1 that contains a dat...; Q147. You need to recommend the appropriate purchasing model and deployment option for the 30 ne...; Q148. You have an Azure subscription that contains the resources shown in the following table. (...; Q149. You have an Azure SQL database. You are reviewing a slow performing query as shown in the ...; Q150. What should you implement to meet the disaster recovery requirements for the PaaS solution...; Q151. You have SQL Server on an Azure virtual machine. You need to use Policy-Based Management i...; Q152. You have SQL Server on an Azure virtual machine that contains a database named Db1. You ne...; Q153. You have an Azure subscription that contains an Azure Data Factory version 2 (V2) data fac...; Q154. You receive numerous alerts from Azure Monitor for an Azure SQL database. You need to redu...; Q155. You have an Azure Data Lake Storage Gen2 container. Data is ingested into the container, a...; Q156. You are building a database backup solution for a SQL Server database hosted on an Azure v...; Q157. You have an Azure subscription. You need to deploy an Azure SQL managed instance by using ...; Q158. You have an Azure SQL database named DB1. The automatic tuning options for DB1 are configu...; Q159. You are planning disaster recovery for the failover group of an Azure SQL Database managed...; Q160. You have an Azure SQL database. You discover that the plan cache is full of compiled plans...; Q161. HOTSPOT You are building an Azure Stream Analytics job to retrieve game data. You need to ...; Q162. You have a SQL Server on Azure Virtual Machines instance named VM1 . You run the following...; Q163. You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance c...; Q164. You have an Azure SQL database. The database contains a table that uses a columnstore inde...; Q165. Note: This question is part of a series of questions that present the same scenario. Each ...; Q166. You have an Azure data factory that has two pipelines named PipelineA and PipelineB. Pipel...; Q167. You have an Azure SQL database named DB1 that contains two tables named Table1 and Table2....; Q168. You are building a database in an Azure Synapse Analytics serverless SQL pool. You have da...; Q169. You need to recommend a configuration for ManufacturingSQLDb1 after the migration to Azure...; Q170. You have SQL Server on an Azure virtual machine. You review the query plan shown in the fo...; Q171. You have an Azure subscription that contains a resource group named RG1. RG1 contains an i...; Q172. You have an Azure subscription that contains an Azure SQL managed instance named SQLMi1 an...; Q173. You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and an Azure Data Lake ...; Q174. You have SQL Server on an Azure virtual machine named SQL1. SQL1 has an agent job to back ...; Q175. You have an Azure Synapse Analytics workspace named WS1 that contains an Apache Spark pool...; Q176. You have the following Transact-SQL query. (Exhibit) Which column returned by the query re...; Q177. You have SQL Server on an Azure virtual machine that contains a database named DB1. You vi...; Q178. You have an on-premises Microsoft SQL Server 2019 instance named SQL1 that hosts a databas...; Q179. You have an Azure SQL managed instance. You need to restore a database named DB1 by using ...; Q180. You have an instance of SQL Server on Azure Virtual Machines named VM1. You need to use an...; Q181. You configure version control for an Azure Data Factory instance as shown in the following...; Q182. You have an Azure subscription. You plan to migrate 10 on-premises Microsoft SQL Server in...; Q183. You need to apply 20 built-in Azure Policy definitions to all new and existing Azure SQL D...; Q184. You have an Azure SQL database. You have a query and the associated execution plan as show...; Q185. You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1...; Q186. You have a 50-TB Microsoft SQL Server database named DB1. You need to reduce the time it t...; Q187. You have an Azure subscription that contains the resources shown in the following table. (...; Q188. You are performing exploratory analysis of bus fare data in an Azure Data Lake Storage Gen...; Q189. You are planning the migration of the SERVER1 databases. The solution must meet the busine...; Q190. You need to use an Azure Resource Manager ARM) template to deploy an Azure virtual machine...; Q191. You have an on-premises Microsoft SQL Server 2016 instance that hosts a database named db1...; Q192. You have an instance of SQL Server on Azure Virtual Machines named VM1. You need to implem...; Q193. You have a SQL Server on Azure Virtual Machines instance named VM1 . You run the following...; Q194. Your on-premises network contains a server that hosts a 60-TB database named DB 1. The net...; Q195. You are building a database in an Azure Synapse Analytics serverless SQL pool. You have da...; Q196. You configure a long-term retention policy for an Azure SQL database as shown in the exhib...; Q197. You have an Azure Data Factory pipeline that performs an incremental load of source data t...; Q198. DRAG DROP You have SQL Server 2019 on an Azure virtual machine that contains an SSISDB dat...; Q199. You have an Azure SQL database named DB1 in the General Purpose service tier. The performa...; Q200. You have an Azure Data Factory instance named ADF1 and two Azure Synapse Analytics workspa...; Q201. You plan to develop a dataset named Purchases by using Azure Databricks. Purchases will co...; Q202. What should you implement to meet the disaster recovery requirements for the PaaS solution...; Q203. You have an Azure subscription that contains the resources shown in the following table. (...; Q204. You have a new Azure SQL database. The database contains a column that stores confidential...; Q205. You need to implement the surrogate key for the retail store table. The solution must meet...; Q206. You have an Azure subscription that contains an Azure SQL managed instance, a database nam...; Q207. You have an Azure subscription that contain an Azure SQL managed instance named SQLMI1 and...; Q208. You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound tra...; Q209. You have a Microsoft SQL Server database named DB1 that contains a table named Table1. The...; Q210. You have SQL Server on an Azure virtual machine that contains a database named DB1. The da...; Q211. You have an Azure subscription that is linked to a hybrid Azure Active Directory (Azure AD...; Q212. You have an Azure SQL logical server. You run the following script. (Exhibit)...; Q213. You have an Azure SQL database named DBI that contains a nonclustered index named index1. ...; Q214. You have an Azure SQL database named DB3. You need to provide a user named DevUser with th...; Q215. You have SQL Server on Azure virtual machines in an availability group. You have a databas...; Q216. What should you use to migrate the PostgreSQL database?...; Q217. You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1...; Q218. You have an Azure SQL database named DB1 that contains a private certificate named Sales. ...; Q219. You have an Azure subscription. You plan to deploy a new Azure virtual machine that will h...; Q220. You manage an enterprise data warehouse in Azure Synapse Analytics. Users report slow perf...; Q221. Task 2 You need to configure your user account as the Azure AD admin for the server named ...; Q222. You need to configure user authentication for the SERVER1 databases. The solution must mee...; Q223. You have an Azure subscription. You need to deploy an Azure SQL managed instance that meet...; Q224. You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1...; Q225. You have SQL Server on an Azure virtual machine. You need to add a 4-TB volume that meets ...; Q226. You have a SQL Server on Azure Virtual Machines instance that hosts a database named Db1. ...; Q227. You are building an Azure Stream Analytics job to retrieve game data. You need to ensure t...; Q228. What should you implement to meet the disaster recovery requirements for the PaaS solution...; Q229. You need to configure user authentication for the SERVER1 databases. The solution must mee...; Q230. You have an Azure subscription that contains an Azure SQL managed instance, a database nam...; Q231. You have an Azure SQL database named sqldb1. You need to minimize the possibility of Query...; Q232. A data engineer creates a table to store employee information for a new application. All e...; Q233. You have an Azure Active Directory (Azure AD) tenant named contoso.com that contains a use...; Q234. You have an Azure SQL database named db1. You need to retrieve the resource usage of db1 f...; Q235. You have a new Azure SQL database. The database contains a column that stores confidential...; Q236. You are designing an anomaly detection solution for streaming data from an Azure IoT hub. ...; Q237. You are planning the migration of the SERVER1 databases. The solution must meet the busine...; Q238. You plan to migrate on-premises Microsoft SQL Server databases to Azure. You need to ident...; Q239. You create a new Azure SQL managed instance named SQL1 and enable Database Mail extended s...; Q240. You are evaluating the role assignments. For each of the following statements, select Yes ...; Q241. You are building a database in an Azure Synapse Analytics serverless SQL pool. You have da...; Q242. You have an Azure subscription that is linked to an Azure AD tenant named contoso.com. The...; Q243. You are creating a managed data warehouse solution on Microsoft Azure. You must use PolyBa...; Q244. You have SQL Server on an Azure virtual machine. You need to add a 4-TB volume that meets ...; Q245. You have two Azure virtual machines named VM1 and VM2 that run Windows Server 2019. VM1 an...; Q246. You need to identify the cause of the performance issues on SalesSQLDb1. Which two dynamic...; Q247. You are building an Azure Stream Analytics job to retrieve game data. You need to ensure t...; Q248. You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 co...; Q249. You have an Azure Data Factory pipeline that is triggered hourly. The pipeline has had 100...; Q250. You have an Azure subscription that contains the resources shown in the following table. (...; Q251. You have an Azure SQL database that contains a table named Customer. Customer has the colu...; Q252. You have an Azure subscription. You plan to deploy an Azure SQL database by using an Azure...; Q253. You have an Azure SQL database that contains a table named factSales. FactSales contains t...; Q254. You need to recommend an availability strategy for an Azure SQL database. The strategy mus...; Q255. You need to recommend a configuration for ManufacturingSQLDb1 after the migration to Azure...; Q256. You have an Azure Synapse Analytics workspace named WS1 that contains an Apache Spark pool...; Q257. You have an Azure subscription that contains an Azure SQL database named SQLDb1. SQLDb1 co...; Q258. You need to recommend a configuration for ManufacturingSQLDb1 after the migration to Azure...; Q259. You have SQL Server on an Azure virtual machine named SQL1. SQL1 has an agent job to back ...; Q260. You have an Azure SQL database named DB1 in the General Purpose service tier. The performa...; Q261. You plan to create a table in an Azure Synapse Analytics dedicated SQL pool. Data in the t...; Q262. A data engineer creates a table to store employee information for a new application. All e...; Q263. You have SQL Server on Azure virtual machines in an availability group. You have a databas...; Q264. You have an Azure SQL database named DB1. DB1 has a table named Table1 that contains the f...; Q265. You have an on-premises app named App1 that stores data in an on-premises Microsoft SQL Se...; Q266. You plan to migrate on-premises Microsoft SQL Server databases to Azure. You need to ident...; Q267. You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Ma...; Q268. You have an Azure Active Directory (Azure AD) tenant named contoso.com that contains a use...; Q269. Note: This question is part of a series of questions that present the same scenario. Each ...; Q270. You have an Azure subscription that contains an Azure SQL managed instance, a database nam...; Q271. You have an Azure SQL database named DB1. DB1 contains a table that has a column named Col...; Q272. Note: This question is part of a series of questions that present the same scenario. Each ...; Q273. Note: This question is part of a series of questions that present the same scenario. Each ...

Join the discussion

Question 1/273

Add Comments

Download PDF File