Question 281
Open question ↗You have an Azure subscription that contains an Azure Synapse Analytics dedicated SQL pool named Pool1.
You need to monitor Pool1. The solution must ensure that you capture the start and end times of each query completed in Pool1.
Which diagnostic setting should you use?
Question 282
Open question ↗You have an Azure subscription that contains an Azure data factory named ADF1 and a Log Analytics workspace named Workspace1.
You need to configure ADF1 to send execution information for pipelines to Workspace1.
What should you configure?
Question 283
Open question ↗You have an Azure Blob storage account named storage1 and an Azure Synapse Analytics serverless SQL poo1 named Pool1.
From Pool1, you plan to run ad-hoc queries that target storage1.
You need to ensure that you can use shared access signature (SAS) authorization without defining a data source.
What should you create first?
Question 284
Open question ↗You have an Azure subscription that contains an Azure Synapse Analytics workspace named Workspace1, a Log Analytics workspace named Workspace2, and an Azure Data Lake Storage Gen2 container named Container1.
Workspace1 contains an Apache Spark job named Job1 that writes data to Container1. Workspace1 sends diagnostics to Workspace2.
From Synapse Studio, you submit Job1.
What should you use to review the LogQuery output of the job?
Question 285
Open question ↗You have an Azure subscription that contains an Azure Data Lake Storage Gen2 container named Container1 and an Azure Synapse Analytics workspace named Workspace1.
Workspace1 contains multiple Apache Spark jobs that reference a large dataset in Container1.
You need to optimize the run times of the jobs.
What should you do?
Question 286
Open question ↗You have an Azure subscription that contains an Azure Synapse Analytics account and an Azure Data Lake Storage Gen2 account named storage1.storage1 contains a 20-TB Delta table.
You run the following Python code.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Question 287
Open question ↗You have an Azure Stream Analytics job that reads data from an Azure event hub.
You need to evaluate whether the job processes data as quickly as the data arrives or cannot keep up.
Which metric should you review?
Question 288
Open question ↗You have a Log Analytics workspace named laworkspace1.
You have an Azure Synapse Analytics workspace named saworkspace1 that contains an Apache Spark pool named Pool1 and has a system-assigned managed identity.
You need to collect and send metrics to laworkspace1 from applications that use Pool1. The solution must minimize unauthorized access to laworkspace1.
Which four 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.
Question 289
Open question ↗You need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements.
What should you create?
Question 290
Open question ↗You need to design an analytical storage solution for the transactional data. The solution must meet the sales transaction dataset requirements.
What should you include in the solution? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
