Join the discussion
Question 1/184
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:

Explanation

Step 1: Create a database role named Role1 and grant Role1 SELECT permissions to schema You need to grant Group1 read-only permissions to all the tables and views in schema1.
Place one or more database users into a database role and then assign permissions to the database role.
Step 2: Assign Rol1 to the Group database user
Step 3: Assign the Azure role-based access control (Azure RBAC) Reader role for dw1 to Group1 Reference:
https://docs.microsoft.com/en-us/azure/data-share/how-to-share-from-sql
Add Comments
- Other Question (184q)
- Q1. You have an Azure Active Directory (Azure AD) tenant that contains a security group named ...
- Q2. You are designing the folder structure for an Azure Data Lake Storage Gen2 account. You id...
- Q3. You have an Azure SQL database named Database1 and two Azure event hubs named HubA and Hub...
- Q4. You have an Apache Spark DataFrame named temperatures. A sample of the data is shown in th...
- Q5. You have an Azure subscription. You need to deploy an Azure Data Lake Storage Gen2 Premium...
- Q6. You have an Azure Synapse Analytics serverless SQL pool, an Azure Synapse Analytics dedica...
- Q7. You plan to create an Azure Synapse Analytics dedicated SQL pool. You need to minimize the...
- Q8. You have a self-hosted integration runtime in Azure Data Factory. The current status of th...
- Q9. You have a data model that you plan to implement in a data warehouse in Azure Synapse Anal...
- Q10. You have an Azure Data Factory pipeline that contains a data flow. The data flow contains ...
- Q11. You have a SQL pool in Azure Synapse. You plan to load data from Azure Blob storage to a s...
- Q12. You have an Azure subscription that contains an Azure Synapse Analytics workspace named wo...
- Q13. You have an Azure subscription that contains the following resources: An Azure Active Dire...
- Q14. You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Sales.O...
- Q15. What should you recommend using to secure sensitive customer contact information?...
- Q16. You plan to implement an Azure Data Lake Gen2 storage account. You need to ensure that the...
- Q17. You have an enterprise data warehouse in Azure Synapse Analytics that contains a table nam...
- Q18. You are building an Azure Stream Analytics job that queries reference data from a product ...
- Q19. You store files in an Azure Data Lake Storage Gen2 container. The container has the storag...
- Q20. You are designing an anomaly detection solution for streaming data from an Azure IoT hub. ...
- Q21. You need to implement an Azure Synapse Analytics database object for storing the sales tra...
- Q22. You are creating an Azure Data Factory data flow that will ingest data from a CSV file, ca...
- Q23. You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Sales.O...
- Q24. You have the following Azure Data Factory pipelines * ingest Data from System 1 * Ingest D...
- Q25. You have an Azure subscription that contains an Azure Databricks workspace. The workspace ...
- Q26. You have an Azure Storage account that generates 200.000 new files daily. The file names h...
- Q27. You are building an Azure Stream Analytics job to retrieve game data. You need to ensure t...
- Q28. You need to output files from Azure Data Factory. Which file format should you use for eac...
- Q29. You have an Azure subscription that contains an Azure Synapse Analytics workspace named wo...
- Q30. You are designing a monitoring solution for a fleet of 500 vehicles. Each vehicle has a GP...
- Q31. You plan to ingest streaming social media data by using Azure Stream Analytics. The data w...
- Q32. You have an Azure data factory. You need to ensure that pipeline-run data is retained for ...
- Q33. You build an Azure Data Factory pipeline to move data from an Azure Data Lake Storage Gen2...
- Q34. You are building an Azure Stream Analytics job to identify how much time a user spends int...
- Q35. You need to collect application metrics, streaming query events, and application log messa...
- Q36. You have an on-premises data warehouse that includes the following fact tables. Both table...
- Q37. You have an Azure Data Factory pipeline that contains a data flow. The data flow contains ...
- Q38. You are designing an Azure Databricks interactive cluster. The cluster will be used infreq...
- Q39. You have an Azure Data Factory pipeline shown the following exhibit. (Exhibit) The executi...
- Q40. You have an Azure Databricks workspace named workspace1 in the Standard pricing tier. You ...
- Q41. You have the Azure Synapse Analytics pipeline shown in the following exhibit. (Exhibit) Yo...
- Q42. You are implementing an Azure Stream Analytics solution to process event data from devices...
- Q43. You are responsible for providing access to an Azure Data Lake Storage Gen2 account. Your ...
- Q44. You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and an Azure Data Lake ...
- Q45. You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Sales.O...
- Q46. You have a table named SalesFact in an enterprise data warehouse in Azure Synapse Analytic...
- Q47. You have two Azure Data Factory instances named ADFdev and ADFprod. ADFdev connects to an ...
- Q48. You use Azure Data Lake Storage Gen2. You need to ensure that workloads can use filter pre...
- Q49. You have an Azure Data Factory that contains 10 pipelines. You need to label each pipeline...
- Q50. You are implementing Azure Stream Analytics windowing functions. Which windowing function ...
- Q51. You have an Azure Storage account that generates 200,000 new files daily. The file names h...
- Q52. You have an Azure Stream Analytics job that is a Stream Analytics project solution in Micr...
- Q53. You need to implement a Type 3 slowly changing dimension (SCD) for product category data i...
- Q54. You have an Azure Synapse workspace named MyWorkspace that contains an Apache Spark databa...
- Q55. You have two Azure Storage accounts named Storage1 and Storage2. Each account holds one co...
- Q56. You have an Azure Synapse Analytics pipeline named Pipeline1 that contains a data flow act...
- Q57. You have a SQL pool in Azure Synapse. You plan to load data from Azure Blob storage to a s...
- Q58. You have an Azure Synapse Analytics dedicated SQL pool that contains the users shown in th...
- Q59. You plan to develop a dataset named Purchases by using Azure databricks Purchases will con...
- Q60. You have an Apache Spark DataFrame named temperatures. A sample of the data is shown in th...
- Q61. You need to design a data storage structure for the product sales transactions. The soluti...
- Q62. You need to implement an Azure Synapse Analytics database object for storing the sales tra...
- Q63. You have an Azure subscription that contains a logical Microsoft SQL server named Server1....
- Q64. You have an Azure subscription. You plan to build a data warehouse in an Azure Synapse Ana...
- Q65. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q66. You are designing an Azure Databricks cluster that runs user-defined local processes. You ...
- Q67. You need to implement an Azure Databricks cluster that automatically connects to Azure Dat...
- Q68. You are designing an application that will store petabytes of medical imaging data When th...
- Q69. You are building a database in an Azure Synapse Analytics serverless SQL pool. You have da...
- Q70. You have the following Azure Stream Analytics query. (Exhibit) For each of the following s...
- Q71. You are designing a slowly changing dimension (SCD) for supplier data in an Azure Synapse ...
- Q72. You are designing the folder structure for an Azure Data Lake Storage Gen2 account. You id...
- Q73. You are planning the deployment of Azure Data Lake Storage Gen2. You have the following tw...
- Q74. You are building an Azure Synapse Analytics dedicated SQL pool that will contain a fact ta...
- Q75. You develop a dataset named DBTBL1 by using Azure Databricks. DBTBL1 contains the followin...
- Q76. You have the following Azure Stream Analytics query. (Exhibit) For each of the following s...
- Q77. You build an Azure Data Factory pipeline to move data from an Azure Data Lake Storage Gen2...
- Q78. You have an Azure Synapse Analytics SQL pool named Pool1 on a logical Microsoft SQL server...
- Q79. You have two fact tables named Flight and Weather. Queries targeting the tables will be ba...
- Q80. You are building an Azure Stream Analytics job to identify how much time a user spends int...
- Q81. You are designing an Azure Stream Analytics solution that receives instant messaging data ...
- Q82. You have an Azure Data Lake Storage Gen2 account that contains a container named container...
- Q83. You have an Azure Data Lake Storage Gen2 account that contains a JSON file for customers. ...
- Q84. You have an Azure Data Lake Storage Gen2 account that contains a container named container...
- Q85. You need to create an Azure Data Factory pipeline to process data for the following three ...
- Q86. You plan to create a real-time monitoring app that alerts users when a device travels more...
- Q87. You have an Azure subscription that contains an Azure Synapse Analytics workspace named wo...
- Q88. You need to create an Azure Data Factory pipeline to process data for the following three ...
- Q89. You need to build a solution to ensure that users can query specific files in an Azure Dat...
- Q90. You are incrementally loading data into fact tables in an Azure Synapse Analytics dedicate...
- Q91. You have an Azure Synapse Analytics job that uses Scala. You need to view the status of th...
- Q92. You have an Azure subscription that contains an Azure Data Lake Storage account. The stora...
- Q93. You use Azure Data Lake Storage Gen2 to store data that data scientists and data engineers...
- Q94. You have an Azure Synapse Analytics dedicated SQL pool. You run PDW_SHOWSPACEUSED(dbo,Fact...
- Q95. You need to ensure that the Twitter feed data can be analyzed in the dedicated SQL pool. T...
- Q96. From a website analytics system, you receive data extracts about user interactions such as...
- Q97. Which Azure Data Factory components should you recommend using together to import the dail...
- Q98. You are designing an Azure Stream Analytics job to process incoming events from sensors in...
- Q99. You have an Azure Data Lake Storage Gen2 account that contains a JSON file for customers. ...
- Q100. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q101. You have an enterprise data warehouse in Azure Synapse Analytics named DW1 on a server nam...
- Q102. You have an Azure subscription that contains a logical Microsoft SQL server named Server1....
- Q103. You have an Azure subscription. You plan to build a data warehouse in an Azure Synapse Ana...
- Q104. You are planning the deployment of Azure Data Lake Storage Gen2. You have the following tw...
- Q105. The following code segment is used to create an Azure Databricks cluster. (Exhibit) For ea...
- Q106. You store files in an Azure Data Lake Storage Gen2 container. The container has the storag...
- Q107. You are designing an Azure Data Lake Storage Gen2 container to store data for the human re...
- Q108. You are building an Azure Stream Analytics job to identify how much time a user spends int...
- Q109. What should you do to improve high availability of the real-time data processing solution?...
- Q110. A company purchases IoT devices to monitor manufacturing machinery. The company uses an Io...
- Q111. You build an Azure Data Factory pipeline to move data from an Azure Data Lake Storage Gen2...
- Q112. You have a Microsoft Purview account. The Lineage view of a CSV file is shown in the follo...
- Q113. You need to collect application metrics, streaming query events, and application log messa...
- Q114. You have an Azure Databricks workspace that contains a Delta Lake dimension table named Ta...
- Q115. You need to create a partitioned table in an Azure Synapse Analytics dedicated SQL pool. H...
- Q116. You plan to create a table in an Azure Synapse Analytics dedicated SQL pool. Data in the t...
- Q117. You have an Azure Data Factory pipeline that is triggered hourly. The pipeline has had 100...
- Q118. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q119. You need to create an Azure Data Factory pipeline to process data for the following three ...
- Q120. You have an Azure Stream Analytics job that is a Stream Analytics project solution in Micr...
- Q121. You need to create a partitioned table in an Azure Synapse Analytics dedicated SQL pool. H...
- Q122. You need to collect application metrics, streaming query events, and application log messa...
- Q123. You develop a dataset named DBTBL1 by using Azure Databricks. DBTBL1 contains the followin...
- Q124. You have an Azure subscription. You plan to build a data warehouse in an Azure Synapse Ana...
- Q125. You are creating a new notebook in Azure Databricks that will support R as the primary lan...
- Q126. You have an Azure Synapse Analytics serverless SQ1 pool. You have an Azure Data Lake Stora...
- Q127. You have an Azure Stream Analytics job that is a Stream Analytics project solution in Micr...
- Q128. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q129. You are responsible for providing access to an Azure Data Lake Storage Gen2 account. Your ...
- Q130. You have an Azure Synapse Analytics dedicated SQL pool that contains the users shown in th...
- Q131. The following code segment is used to create an Azure Databricks cluster. (Exhibit) For ea...
- Q132. You need to implement an Azure Synapse Analytics database object for storing the sales tra...
- Q133. You are implementing Azure Stream Analytics windowing functions. Which windowing function ...
- Q134. You have Azure Data Factory configured with Azure Repos Git integration. The collaboration...
- Q135. You have an on-premises data warehouse that includes the following fact tables. Both table...
- Q136. You need to create a partitioned table in an Azure Synapse Analytics dedicated SQL pool. H...
- Q137. You have an Azure subscription that contains an Azure Data Lake Storage account. The stora...
- Q138. You have a table named SalesFact in an enterprise data warehouse in Azure Synapse Analytic...
- Q139. You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool...
- Q140. What should you do to improve high availability of the real-time data processing solution?...
- Q141. You have an enterprise data warehouse in Azure Synapse Analytics that contains a table nam...
- Q142. You are developing a solution using a Lambda architecture on Microsoft Azure. The data at ...
- Q143. You are building an Azure Stream Analytics job that queries reference data from a product ...
- Q144. You have the following Azure Data Factory pipelines * ingest Data from System 1 * Ingest D...
- Q145. You have an enterprise data warehouse in Azure Synapse Analytics that contains a table nam...
- Q146. Which Azure Data Factory components should you recommend using together to import the dail...
- Q147. You are monitoring an Azure Stream Analytics job. The Backlogged Input Events count has be...
- Q148. You have an Azure Data Factory that contains 10 pipelines. You need to label each pipeline...
- Q149. You have an Azure Data Lake Storage Gen2 account that contains a JSON file for customers. ...
- Q150. You use Azure Stream Analytics to receive Twitter data from Azure Event Hubs and to output...
- Q151. You are designing a monitoring solution for a fleet of 500 vehicles. Each vehicle has a GP...
- Q152. You plan to create a table in an Azure Synapse Analytics dedicated SQL pool. Data in the t...
- Q153. You store files in an Azure Data Lake Storage Gen2 container. The container has the storag...
- Q154. You are building an Azure Stream Analytics job to retrieve game data. You need to ensure t...
- Q155. You have the following Azure Stream Analytics query. (Exhibit) For each of the following s...
- Q156. You are designing an Azure Stream Analytics job to process incoming events from sensors in...
- Q157. You have a Microsoft SQL Server database that uses a third normal form schema. You plan to...
- Q158. You need to design a data retention solution for the Twitter feed data records. The soluti...
- Q159. You have an Azure SQL database named Database1 and two Azure event hubs named HubA and Hub...
- Q160. You have an Azure Active Directory (Azure AD) tenant that contains a security group named ...
- Q161. You are implementing a star schema in an Azure Synapse Analytics dedicated SQL pool. You p...
- Q162. You are building an Azure Data Factory solution to process data received from Azure Event ...
- Q163. You are creating dimensions for a data warehouse in an Azure Synapse Analytics dedicated S...
- Q164. You have an Azure Data Factory instance named ADF1 and two Azure Synapse Analytics workspa...
- Q165. You have an Azure subscription that contains an Azure Databricks workspace named databrick...
- Q166. You have an enterprise data warehouse in Azure Synapse Analytics. Using PolyBase, you crea...
- Q167. You are building an Azure Stream Analytics job to identify how much time a user spends int...
- Q168. You are building an Azure Analytics query that will receive input data from Azure IoT Hub ...
- Q169. You have several Azure Data Factory pipelines that contain a mix of the following types of...
- Q170. You are responsible for providing access to an Azure Data Lake Storage Gen2 account. Your ...
- Q171. You have an Azure Data Lake Storage Gen2 account that contains a JSON file for customers. ...
- Q172. You have an Azure Data Factory instance that contains two pipelines named Pipeline1 and Pi...
- Q173. You have an Azure Synapse Analytics dedicated SQL pool named SA1 that contains a table nam...
- Q174. You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and an Azure Data Lake ...
- Q175. You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool...
- Q176. You need to output files from Azure Data Factory. Which file format should you use for eac...
- Q177. You have an Azure Storage account that generates 200.000 new files daily. The file names h...
- Q178. You need to implement an Azure Synapse Analytics database object for storing the sales tra...
- Q179. You need to design a data storage structure for the product sales transactions. The soluti...
- Q180. The following code segment is used to create an Azure Databricks cluster. (Exhibit) For ea...
- Q181. You have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The table ...
- Q182. You have an Azure data factory. You need to examine the pipeline failures from the last 18...
- Q183. You have a SQL pool in Azure Synapse. You plan to load data from Azure Blob storage to a s...
- Q184. You are designing a monitoring solution for a fleet of 500 vehicles. Each vehicle has a GP...
