Join the discussion
Question 1/223
You have an Azure Active Directory (Azure AD) tenant that contains a security group named Group1. You have an Azure Synapse Analytics dedicated SQL pool named dw1 that contains a schema named schema1.
You need to grant Group1 read-only permissions to all the tables and views in schema1. The solution must use the principle of least privilege.
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.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

You need to grant Group1 read-only permissions to all the tables and views in schema1. The solution must use the principle of least privilege.
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.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/azure/data-share/how-to-share-from-sql
Add Comments
- Other Question (223q)
- Q1. You have an Azure Active Directory (Azure AD) tenant that contains a security group named ...
- Q2. You are incrementally loading data into fact tables in an Azure Synapse Analytics dedicate...
- Q3. You need to implement a Type 3 slowly changing dimension (SCD) for product category data i...
- Q4. You are designing an Azure Data Lake Storage Gen2 structure for telemetry data from 25 mil...
- Q5. You have the following Azure Stream Analytics query. (Exhibit) For each of the following s...
- Q6. You have an Apache Spark DataFrame named temperatures. A sample of the data is shown in th...
- Q7. You have an Azure Synapse Analytics dedicated SQL pool. You need to create a table named F...
- Q8. You have an Azure subscription that contains an Azure Synapse Analytics workspace named wo...
- Q9. You need to design a data ingestion and storage solution for the Twitter feeds. The soluti...
- Q10. You plan to create a table in an Azure Synapse Analytics dedicated SQL pool. Data in the t...
- Q11. You have an Azure subscription that contains an Azure Databricks workspace named databrick...
- Q12. You have the following Azure Stream Analytics query. (Exhibit) For each of the following s...
- Q13. You are processing streaming data from vehicles that pass through a toll booth. You need t...
- Q14. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q15. You are implementing Azure Stream Analytics windowing functions. Which windowing function ...
- Q16. You build an Azure Data Factory pipeline to move data from an Azure Data Lake Storage Gen2...
- Q17. You need to create an Azure Data Factory pipeline to process data for the following three ...
- Q18. You are designing an Azure Stream Analytics job to process incoming events from sensors in...
- Q19. You have an Azure subscription that contains an Azure Databricks workspace named databrick...
- Q20. You have an Azure Synapse Analytics dedicated SQL pool. You need to ensure that data in th...
- Q21. From a website analytics system, you receive data extracts about user interactions such as...
- Q22. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q23. You have an Azure SQL database named DB1 and an Azure Data Factory data pipeline named pip...
- Q24. You have an Azure Synapse Analytics dedicated SQL Pool1. Pool1 contains a partitioned fact...
- Q25. You plan to monitor an Azure data factory by using the Monitor & Manage app. You need ...
- Q26. You plan to develop a dataset named Purchases by using Azure databricks Purchases will con...
- Q27. You are designing an Azure Stream Analytics solution that receives instant messaging data ...
- Q28. You have a Microsoft SQL Server database that uses a third normal form schema. You plan to...
- Q29. You are developing a solution using a Lambda architecture on Microsoft Azure. The data at ...
- Q30. A company plans to use Platform-as-a-Service (PaaS) to create the new data pipeline proces...
- Q31. You have an Azure Data Factory pipeline named pipeline1 that includes a Copy activity name...
- Q32. You have an Azure subscription. You plan to build a data warehouse in an Azure Synapse Ana...
- Q33. You plan to create an Azure Data Lake Storage Gen2 account You need to recommend a storage...
- Q34. You have a self-hosted integration runtime in Azure Data Factory. The current status of th...
- Q35. You are developing a solution using a Lambda architecture on Microsoft Azure. The data at ...
- Q36. You are creating dimensions for a data warehouse in an Azure Synapse Analytics dedicated S...
- Q37. You have an Azure subscription that contains the resources shown in the following table. (...
- Q38. A company uses Azure Stream Analytics to monitor devices. The company plans to double the ...
- Q39. You are designing a fact table named FactPurchase in an Azure Synapse Analytics dedicated ...
- Q40. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q41. You have an Azure Data Lake Storage account that contains CSV files. The CSV files contain...
- Q42. You have an Azure subscription that contains the following resources: * An Azure Active Di...
- Q43. You have an Azure subscription that contains an Azure Databricks workspace. The workspace ...
- Q44. You plan to develop a dataset named Purchases by using Azure databricks Purchases will con...
- Q45. You have an Azure Synapse Analytics dedicated SQL pool named SQL1 that contains a hash-dis...
- Q46. You need to design a data storage structure for the product sales transactions. The soluti...
- Q47. that has the activity shown in the following exhibit. (Exhibit) Use the drop-down menus to...
- Q48. You need to design a data storage structure for the product sales transactions. The soluti...
- Q49. You have an Azure Synapse Analytics dedicated SQL pool named pool1. You plan to implement ...
- Q50. You are designing the folder structure for an Azure Data Lake Storage Gen2 account. You id...
- Q51. You are creating an Azure Data Factory data flow that will ingest data from a CSV file, ca...
- Q52. You are building an Azure Stream Analytics job to identify how much time a user spends int...
- Q53. You are developing a solution using a Lambda architecture on Microsoft Azure. The data at ...
- Q54. You have an Azure SQL database named Database1 and two Azure event hubs named HubA and Hub...
- Q55. You need to create an Azure Data Factory pipeline to process data for the following three ...
- Q56. You have an Azure Data Lake Storage Gen2 account that contains a JSON file for customers. ...
- Q57. You have a table in an Azure Synapse Analytics dedicated SQL pool. The table was created b...
- Q58. You need to create an Azure Data Factory pipeline to process data for the following three ...
- Q59. You have an Azure subscription that contains an Azure Data Lake Storage account. The stora...
- Q60. You need to collect application metrics, streaming query events, and application log messa...
- Q61. You have an Azure data factory. You need to ensure that pipeline-run data is retained for ...
- Q62. You have an Azure subscription that contains an Azure Data Lake Storage account. The stora...
- Q63. You have an enterprise data warehouse in Azure Synapse Analytics. Using PolyBase, you crea...
- Q64. You have an Apache Spark DataFrame named temperatures. A sample of the data is shown in th...
- Q65. From a website analytics system, you receive data extracts about user interactions such as...
- Q66. You are building an Azure Analytics query that will receive input data from Azure IoT Hub ...
- Q67. You are building an Azure Data Factory solution to process data received from Azure Event ...
- Q68. You have an Azure subscription that contains an Azure Data Lake Storage account. The stora...
- Q69. You have an Azure subscription. You plan to build a data warehouse in an Azure Synapse Ana...
- Q70. You store files in an Azure Data Lake Storage Gen2 container. The container has the storag...
- Q71. You use Azure Data Lake Storage Gen2 to store data that data scientists and data engineers...
- Q72. You are creating an Azure Data Factory data flow that will ingest data from a CSV file, ca...
- Q73. You have an on-premises data warehouse that includes the following fact tables. Both table...
- Q74. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q75. You have a data model that you plan to implement in a data warehouse in Azure Synapse Anal...
- Q76. You have two Azure Storage accounts named Storage1 and Storage2. Each account holds one co...
- Q77. You build an Azure Data Factory pipeline to move data from an Azure Data Lake Storage Gen2...
- Q78. You have an Azure Stream Analytics job. You need to ensure that the job has enough streami...
- Q79. You have an Azure subscription that contains an Azure Data Lake Storage account named myac...
- Q80. You store files in an Azure Data Lake Storage Gen2 container. The container has the storag...
- Q81. You configure version control for an Azure Data Factory instance as shown in the following...
- Q82. You have an Azure event hub named retailhub that has 16 partitions. Transactions are poste...
- Q83. What should you recommend to prevent users outside the Litware on-premises network from ac...
- Q84. You are designing a slowly changing dimension (SCD) for supplier data in an Azure Synapse ...
- Q85. You have an Azure Data Factory pipeline shown the following exhibit. (Exhibit) The executi...
- Q86. You have the Azure Synapse Analytics pipeline shown in the following exhibit. (Exhibit) Yo...
- Q87. You are designing a monitoring solution for a fleet of 500 vehicles. Each vehicle has a GP...
- Q88. that has the activity shown in the following exhibit. (Exhibit) Use the drop-down menus to...
- Q89. You need to build a solution to ensure that users can query specific files in an Azure Dat...
- Q90. You are designing a financial transactions table in an Azure Synapse Analytics dedicated S...
- Q91. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q92. You are designing an inventory updates table in an Azure Synapse Analytics dedicated SQL p...
- Q93. You use Azure Data Factory to prepare data to be queried by Azure Synapse Analytics server...
- Q94. You have a self-hosted integration runtime in Azure Data Factory. The current status of th...
- Q95. You have an Azure Active Directory (Azure AD) tenant that contains a security group named ...
- Q96. You have an Azure Data Lake Storage Gen2 account that contains a container named container...
- Q97. You are building an Azure Data Factory solution to process data received from Azure Event ...
- Q98. You are creating dimensions for a data warehouse in an Azure Synapse Analytics dedicated S...
- Q99. You need to implement a Type 3 slowly changing dimension (SCD) for product category data i...
- Q100. You are building an Azure Stream Analytics job to identify how much time a user spends int...
- Q101. You have a SQL pool in Azure Synapse. You plan to load data from Azure Blob storage to a s...
- Q102. You have an Azure Data Lake Storage Gen2 container. Data is ingested into the container, a...
- Q103. You have an Azure Data Factory pipeline that has the activities shown in the following exh...
- Q104. You have an Azure Blob storage account that contains a folder. The folder contains 120,000...
- Q105. You need to create a partitioned table in an Azure Synapse Analytics dedicated SQL pool. H...
- Q106. Which Azure Data Factory components should you recommend using together to import the dail...
- Q107. You are designing a fact table named FactPurchase in an Azure Synapse Analytics dedicated ...
- Q108. You are developing a solution using a Lambda architecture on Microsoft Azure. The data at ...
- Q109. Which Azure Data Factory components should you recommend using together to import the dail...
- Q110. You manage an enterprise data warehouse in Azure Synapse Analytics. Users report slow perf...
- Q111. You have an Azure event hub named retailhub that has 16 partitions. Transactions are poste...
- Q112. You need to implement an Azure Databricks cluster that automatically connects to Azure Dat...
- Q113. You need to create a partitioned table in an Azure Synapse Analytics dedicated SQL pool. H...
- Q114. You are designing a highly available Azure Data Lake Storage solution that will induce geo...
- Q115. You have an Azure subscription that contains a logical Microsoft SQL server named Server1....
- Q116. You need to collect application metrics, streaming query events, and application log messa...
- Q117. Which Azure Data Factory components should you recommend using together to import the dail...
- Q118. You have an Azure Data Lake Storage Gen2 account that contains a JSON file for customers. ...
- Q119. You are batch loading a table in an Azure Synapse Analytics dedicated SQL pool. You need t...
- Q120. You have an enterprise data warehouse in Azure Synapse Analytics. Using PolyBase, you crea...
- Q121. You plan to create a real-time monitoring app that alerts users when a device travels more...
- Q122. You need to design the partitions for the product sales transactions. The solution must me...
- Q123. You have an Apache Spark DataFrame named temperatures. A sample of the data is shown in th...
- Q124. You have an Azure Data Factory version 2 (V2) resource named Df1. Df1 contains a linked se...
- Q125. You have an Azure subscription that contains an Azure Databricks workspace named databrick...
- Q126. You have an Azure Databricks workspace and an Azure Data Lake Storage Gen2 account named s...
- Q127. You have an Azure SQL database named Database1 and two Azure event hubs named HubA and Hub...
- Q128. You have two fact tables named Flight and Weather. Queries targeting the tables will be ba...
- Q129. You have an Azure SQL database named Database1 and two Azure event hubs named HubA and Hub...
- Q130. You are designing an Azure Synapse Analytics dedicated SQL pool. Groups will have access t...
- Q131. You need to implement an Azure Synapse Analytics database object for storing the sales tra...
- Q132. You are designing a dimension table in an Azure Synapse Analytics dedicated SQL pool. You ...
- Q133. You need to implement an Azure Synapse Analytics database object for storing the sales tra...
- Q134. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q135. You have an Azure subscription. You plan to build a data warehouse in an Azure Synapse Ana...
- Q136. You have an enterprise data warehouse in Azure Synapse Analytics named DW1 on a server nam...
- Q137. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q138. You are processing streaming data from vehicles that pass through a toll booth. You need t...
- Q139. You are designing an Azure Data Lake Storage Gen2 container to store data for the human re...
- Q140. You are building an Azure Stream Analytics job to retrieve game data. You need to ensure t...
- Q141. You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Table1....
- Q142. You have an Azure data factory that has the Git repository settings shown in the following...
- Q143. You are building a database in an Azure Synapse Analytics serverless SQL pool. You have da...
- Q144. You have an Azure Synapse Analytics dedicated SQL pool that contains the users shown in th...
- Q145. You are designing a monitoring solution for a fleet of 500 vehicles. Each vehicle has a GP...
- Q146. You have an Azure Synapse Analytics Apache Spark pool named Pool1. You plan to load JSON f...
- Q147. You have an Azure Synapse Analytics dedicated SQL pool named Pool1 that contains an extern...
- Q148. You have a C# application that process data from an Azure IoT hub and performs complex tra...
- Q149. You have an Azure Synapse Analytics dedicated SQL pool named Pool1 that contains a table n...
- Q150. You have the following Azure Stream Analytics query. (Exhibit) For each of the following s...
- Q151. You have an Azure subscription that is linked to a hybrid Azure Active Directory (Azure AD...
- Q152. You have an Azure Storage account that generates 200.000 new files daily. The file names h...
- Q153. You need to create an Azure Data Factory pipeline to process data for the following three ...
- Q154. You are designing an application that will use an Azure Data Lake Storage Gen 2 account to...
- Q155. You need to design a data storage structure for the product sales transactions. The soluti...
- Q156. You are designing a dimension table for a data warehouse. The table will track the value o...
- Q157. You need to implement an Azure Databricks cluster that automatically connects to Azure Dat...
- Q158. You have an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 contains a fact ...
- Q159. You have an Azure subscription that contains an Azure Databricks workspace. The workspace ...
- Q160. You have the following Azure Stream Analytics query. (Exhibit) For each of the following s...
- Q161. You have an Azure data factory named ADM that contains a pipeline named Pipelwe1 Pipeline!...
- Q162. You are designing an Azure Synapse Analytics dedicated SQL pool. Groups will have access t...
- Q163. You plan to create a real-time monitoring app that alerts users when a device travels more...
- Q164. You have an Azure subscription that contains a logical Microsoft SQL server named Server1....
- Q165. You have an Azure subscription that contains an Azure Data Lake Storage account named myac...
- Q166. You have an enterprise data warehouse in Azure Synapse Analytics. Using PolyBase, you crea...
- Q167. You plan to perform batch processing in Azure Databricks once daily. Which type of Databri...
- Q168. A company plans to use Apache Spark analytics to analyze intrusion detection data. You nee...
- Q169. You have an Azure Synapse Analytics SQL pool named Pool1 on a logical Microsoft SQL server...
- Q170. You are designing a solution that will copy Parquet files stored in an Azure Blob storage ...
- Q171. You need to create an Azure Data Factory pipeline to process data for the following three ...
- Q172. You have an Azure Synapse Analytics dedicated SQL pool that contains the users shown in th...
- Q173. You have an Azure Synapse Analytics dedicated SQL pool. You run PDW_SHOWSPACEUSED(dbo,Fact...
- Q174. that has the activity shown in the following exhibit. (Exhibit) Use the drop-down menus to...
- Q175. You need to create a partitioned table in an Azure Synapse Analytics dedicated SQL pool. H...
- Q176. You implement an enterprise data warehouse in Azure Synapse Analytics. You have a large fa...
- Q177. You have a table named SalesFact in an enterprise data warehouse in Azure Synapse Analytic...
- Q178. You use PySpark in Azure Databricks to parse the following JSON input. (Exhibit) You need ...
- Q179. You have an Azure data factory that has the Git repository settings shown in the following...
- Q180. You have an Azure Synapse Analytics SQL pool named Pool1 on a logical Microsoft SQL server...
- Q181. You manage an enterprise data warehouse in Azure Synapse Analytics. Users report slow perf...
- Q182. You have the Azure Synapse Analytics pipeline shown in the following exhibit. (Exhibit) Yo...
- Q183. You use Azure Data Factory to prepare data to be queried by Azure Synapse Analytics server...
- Q184. A company uses the Azure Data Lake Storage Gen2 service. You need to design a data archivi...
- Q185. You need to implement an Azure Databricks cluster that automatically connects to Azure Dat...
- Q186. You have an Azure Data Factory pipeline named Pipeline1!. Pipelinel contains a copy activi...
- Q187. You plan to create a real-time monitoring app that alerts users when a device travels more...
- Q188. You are building an Azure Stream Analytics job to retrieve game data. You need to ensure t...
- Q189. You have the following Azure Stream Analytics query. (Exhibit) For each of the following s...
- Q190. You are designing an Azure Stream Analytics solution that receives instant messaging data ...
- Q191. that has the activity shown in the following exhibit. (Exhibit) Use the drop-down menus to...
- Q192. You have an enterprise data warehouse in Azure Synapse Analytics that contains a table nam...
- Q193. You have two Azure Storage accounts named Storage1 and Storage2. Each account holds one co...
- Q194. You have an Azure Stream Analytics job that is a Stream Analytics project solution in Micr...
- Q195. You have the Azure Synapse Analytics pipeline shown in the following exhibit. (Exhibit) Yo...
- Q196. You need to collect application metrics, streaming query events, and application log messa...
- Q197. You are designing an enterprise data warehouse in Azure Synapse Analytics that will store ...
- Q198. You have an Azure Storage account that generates 200,000 new files daily. The file names h...
- Q199. You plan to create a table in an Azure Synapse Analytics dedicated SQL pool. Data in the t...
- Q200. You have an Azure Storage account that generates 200,000 new files daily. The file names h...
- Q201. You have two fact tables named Flight and Weather. Queries targeting the tables will be ba...
- Q202. You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool...
- Q203. You have an Azure subscription that contains an Azure Databricks workspace. The workspace ...
- Q204. You have an Azure Data Factory pipeline that performs an incremental load of source data t...
- Q205. You have an Azure Data Lake Storage Gen2 account named adls2 that is protected by a virtua...
- Q206. You develop a dataset named DBTBL1 by using Azure Databricks. DBTBL1 contains the followin...
- Q207. You have the following Azure Stream Analytics query. (Exhibit) For each of the following s...
- Q208. You are building an Azure Stream Analytics job to retrieve game data. You need to ensure t...
- Q209. You have an Azure Synapse Analytics dedicated SQL pool named SA1 that contains a table nam...
- Q210. You have an Azure Synapse Analytics serverless SQ1 pool. You have an Azure Data Lake Stora...
- Q211. You have a self-hosted integration runtime in Azure Data Factory. The current status of th...
- Q212. You have an Azure Storage account that generates 200,000 new files daily. The file names h...
- Q213. You have the following Azure Stream Analytics query. (Exhibit) For each of the following s...
- Q214. A company uses Azure Stream Analytics to monitor devices. The company plans to double the ...
- Q215. You are designing an application that will store petabytes of medical imaging data When th...
- Q216. You have an Azure Data Lake Storage Gen2 account that contains a JSON file for customers. ...
- Q217. You have an Azure Data Lake Storage Gen 2 account named storage1. You need to recommend a ...
- Q218. You are designing a monitoring solution for a fleet of 500 vehicles. Each vehicle has a GP...
- Q219. You have an enterprise data warehouse in Azure Synapse Analytics named DW1 on a server nam...
- Q220. You configure monitoring for a Microsoft Azure SQL Data Warehouse implementation. The impl...
- Q221. A company uses the Azure Data Lake Storage Gen2 service. You need to design a data archivi...
- Q222. You have an Azure Synapse Analytics dedicated SQL pool. You plan to create a fact table na...
- Q223. You need to ensure that the Twitter feed data can be analyzed in the dedicated SQL pool. T...
