Question 271
Open question ↗You have an Azure Data Lake Storage Gen2 account named account1 that contains a container named container1.
You plan to create lifecycle management policy rules for container1.
You need to ensure that you can create rules that will move blobs between access tiers based on when each blob was accessed last.
What should you do first?
Question 272
Open question ↗You have an Azure subscription that contains the resources shown in the following table.
Diagnostic logs from ADF1 are sent to LA1. ADF1 contains a pipeline named Pipeline1 that copies data from DB1 to Dw1.
You need to perform the following actions:
• Create an action group named AG1.
• Configure an alert in ADF1 to use AG1.
In which resource group should you create AG1?
Question 273
Open question ↗You have an Azure subscription that contains the resources shown in the following table.
You need to ensure that you can run Spark notebooks in ws1.The solution must ensure that you can retrieve secrets from kv1 by using UAMI1.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Question 274
Open question ↗You have an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 contains a fact table named Table1.
You need to identify the extent of the data skew in Table1.
What should you do in Synapse Studio?
Question 275
Open question ↗You have several Azure Data Factory pipelines that contain a mix of the following types of activities:
• Power Query
• Notebook
• Copy
• Jar
Which two Azure services should you use to debug the activities? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Question 276
Open question ↗A company purchases IoT devices to monitor manufacturing machinery. The company uses an Azure IoT Hub to communicate with the IoT devices.
The company must be able to monitor the devices in real-time.
You need to design the solution.
What should you recommend?
Question 277
Open question ↗You have an Azure Data Lake Storage Gen2 account named account1 that contains a container named Container1. Container1 contains two folders named FolderA and FolderB.
You need to configure access control lists (ACLs) to meet the following requirements:
• Group1 must be able to list and read the contents and subfolders of FolderA.
• Group2 must be able to list and read the contents of FolderA and FolderB.
• Group2 must be prevented from reading any other folders at the root of Container1.
How should you configure the ACL permissions for each group? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Question 278
Open question ↗You have an Azure subscription that contains an Azure Synapse Analytics workspace and a user named User1.
You need to ensure that User1 can review the Azure Synapse Analytics database templates from the gallery. The solution must follow the principle of least privilege.
Which role should you assign to User1?
Question 279
Open question ↗You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool named Pool1.
You have the queries shown in the following table.
You are evaluating whether to enable result set caching for Pool1.
Which query results will be cached if result set caching is enabled?
Question 280
Open question ↗You have an Azure subscription that contains an Azure Synapse Analytics workspace name workspace1, workspace1 contains an Azure Synapse Analytics dedicated SQL pool named Pool1.
You create a mapping data flow in an Azure Synapse pipeline that writes data to Pool1.
You execute the data flow and capture the execution information.
You need to identify how long it takes to write the data to Pool1.
Which metric should you use?