MICROSOFT-DP203

Microsoft's DP-203 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?

Microsoft's DP-203 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?

Microsoft's DP-203 You manage an enterprise data warehouse in Azure Synapse Analytics.Users report slow performance when they run commonly used queries. Users do not report performance changes for infrequently used queries.You need to monitor resource utilization to determine the source of the performance issues.Which metric should you monitor?

Microsoft's DP-203 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?

Microsoft's DP-203 You have several Azure Data Factory pipelines that contain a mix of the following types of activities:• Power Query• Notebook• Copy• JarWhich 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. E. Azure Databricks

Microsoft's DP-203 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?

Microsoft's DP-203 You have an Azure Synapse Analytics dedicated SQL pool named pool1.You need to perform a monthly audit of SQL statements that affect sensitive data. The solution must minimize administrative effort.What should you include in the solution?

Microsoft's DP-203 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?

Microsoft's DP-203 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?

Microsoft's DP-203 You have a Log Analytics workspace named la1 and an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 sends logs to la1.You need to identify whether a recently executed query on Pool1 used the result set cache.What are two ways to achieve the goal? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point. E. Review the sys.dm_pdw_request_steps dynamic management view in Pool1.

Microsoft's DP-203 You have an Azure data factory named DF1. DF1 contains a single pipeline that is executed by using a schedule trigger.From Diagnostics settings, you configure pipeline runs to be sent to a resource-specific destination table in a Log Analytics workspace.You need to run KQL queries against the table.Which table should you query?

Microsoft's DP-203 You have an Azure subscription that contains an Azure Synapse workspace named WS1 and an Azure Monitor action group named Group1. WS1 has a dedicated SQL pool.You plan to archive monitoring data for integration activity runs.You need to ensure that you can configure custom alerts based on the archived data that will execute Group1. The solution must minimize administrative effort.Which diagnostic setting should you select?

Microsoft's DP-203 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? E. Query1, Query2, and Query3 only

Microsoft's DP-203 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?

Microsoft's DP-203 You have an Azure data factory named DF1. DF1 contains a pipeline that has five activities.You need to monitor queue times across the activities by using Log Analytics.What should you do in DF1?

Microsoft's DP-203 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?

Microsoft's DP-203 You have an Azure Stream Analytics job named Job1.The metrics of Job1 from the last hour are shown in the following table.The late arrival tolerance for Job1 is set to five seconds.You need to optimize Job1.Which two actions achieve the goal? Each correct answer presents a complete solution.NOTE: Each correct answer is worth one point.

Microsoft's DP-203 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?

Microsoft's DP-203 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?

Microsoft's DP-203 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?

Microsoft's DP-203 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?

Microsoft's DP-203 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?

Microsoft's DP-203 You need to design a data retention solution for the Twitter feed data records. The solution must meet the customer sentiment analytics requirements.Which Azure Storage functionality should you include in the solution?

Microsoft's DP-203 What should you recommend to prevent users outside the Litware on-premises network from accessing the analytical data store?

Microsoft's DP-203 What should you recommend using to secure sensitive customer contact information?

Microsoft's DP-203 What should you do to improve high availability of the real-time data processing solution?