You have two Azure Blob Storage accounts named account1 and account2?You plan to create an Azure Data Factory pipeline that will use scheduled intervals to replicate newly created or modified blobs from account1 to account?You need to recommend a solution to implement the pipeline. The solution must meet the following requirements:* Ensure that the pipeline only copies blobs that were created of modified since the most recent replication event.* Minimize the effort to create the pipeline.What should you recommend?

Create a pipeline that contains a flowlet.

Create a pipeline that contains a Data Flow activity.

Run the Copy Data tool and select Metadata-driven copy task.

Run the Copy Data tool and select Built-in copy task.

You have an Azure data factor/ connected to a Git repository that contains the following branches:* mam: Collaboration branch* abc: Feature branch* xyz: Feature branchYou save charges to a pipeline in the xyz branch.You need to publish the changes to the live serviceWhat should you do first?

Create a pull request to merge the changes into the main branch.

Push the code to a remote origin.

Create a pull request to merge the changes into the abc branch.

Create a pull request to merge the changes into the main branch.

You have an Azure Synapse Analytics dedicated SQL pool named Pcol1. Pool1 contains a table named tabletYou load 5 TB of data into table1.You need to ensure that column store compression is maximized for table1.Which statement should you execute?

ALTER INDEX ALL on table REBUILD

DBCC IIDEXDEFRAG (pool1, table1)

ALTER INDEX ALL on table REORGANIZE

You have an Azure Data Factory pipeline named pipeline1 that includes a Copy activity named Copy1. Copy1 has the following configurations:* The source of Copy1 is a table in an on-premises Microsoft SQL Server instance that is accessed by using a linked service connected via a self-hosted integration runtime.* The sink of Copy1 uses a table in an Azure SQL database that is accessed by using a linked service connected via an Azure integration runtime.You need to maximize the amount of compute resources available to Copy1. The solution must minimize administrative effort.What should you do?

Scale up the data flow runtime of the Azure integration runtime.

Scale up the data flow runtime of the Azure integration runtime and scale out the self-hosted integration runtime.

Scale out the self-hosted integration runtime.

You have an Azure subscription that contains an Azure Data Factory data pipeline named Pipeline1, a Log Analytics workspace named LA1, and a storage account named account1.You need to retain pipeline-run data for 90 days. The solution must meet the following requirements:* The pipeline-run data must be removed automatically after 90 days.* Ongoing costs must be minimized.Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Configure Pipeline1 to send logs to LA1.

From the Diagnostic settings (classic) settings of account1. set the retention period to 90 days.

Configure Pipeline1 to send logs to LA1.

From the Diagnostic settings (classic) settings of account1. set the retention period to 90 days.

Configure Pipeline1 to send logs to account1.

From the Data Retention settings of LA1, set the data retention period to 90 days.

You have an Azure data factory that connects to a Microsoft Purview account. The data 'factory is registered in Microsoft Purview.You update a Data Factory pipeline.You need to ensure that the updated lineage is available in Microsoft Purview.What should you do first?

Disconnect the Microsoft Purview account from the data factory.

Locate the related asset in the Microsoft Purview portal.

Execute an Azure DevOps build pipeline.

You have an Azure Synapse Analytics dedicated SQL pool named Pool1.Pool! contains two tables named SalesFact_Stagmg and SalesFact. Both tables have a matching number of partitions, all of which contain data.You need to load data from SalesFact_Staging to SalesFact by switching a partition.What should you specify when running the alter TABLE statement?

WITH (TRACK.COLUMNS. UPOATED =ON)

A company purchases IoT devices to monitor manufacturing machinery. The company uses an Azure IoTHub 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?

Azure Stream Analytics Edge application using Microsoft Visual Studio.

Azure Analytics Services using Azure portal

Azure Analysis Services using Microsoft visual Studio

Azure Data Factory instance using Microsoft visual Studio

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 the 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.

Resolution errors in inputs processing.

Resolution errors in output processing

You have an Azure subscription that contains a Microsoft Purview account.You need to search the Microsoft Purview Data Catalog to identify assets that have an assetType property of Table or ViewWhich query should you run?

assetType:Table OR assetType:View

You have a Microsoft Entra tenant.The tenant contains an Azure Data Lake Storage Gen2 account named storage! that has two containers named fs1 and fs2. You have a Microsoft Entra group named OepartmentA . You need to meet the following requirements:* OepartmentA must be able to read, write, and list all the files in fs1.* OepartmentA must be prevented from accessing any files in fs2* The solution must use the principle of least privilege.Which role should you assign to DepartmentA?

Storage Blob Data Contributor for fsl

Storage Blob Data Owner for fsl

Storage Blob Data Contributor for storage1

Storage Blob Data Contributor for fsl

You have an Azure subscription that contains an Azure Synapse Analytics account. The account is integrated with an Azure Repos repository named Repo1 and contains a pipeline named Pipeline1. Repo1 contains the branches shown in the following table. From featuredev, you develop and test changes to Pipeline1. You need to publish the changes. What should you do first?

From featuredev. create a pull request.

From main, create a pull request.

Add a Publish_config.json file to the root folder of the collaboration branch.

Microsoft DP-203 Practice Test 8 - Free Online Exam Questions 281-320

Question 1 / 40

Note: The question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it As a result these questions will not appear in the review screen. You have an Azure Data Lake Storage account that contains a staging zone.

You need to design a dairy process to ingest incremental data from the staging zone, transform the data by executing an R script, and then insert the transformed data into a data warehouse in Azure Synapse Analytics.

Solution: You use an Azure Data Factory schedule trigger to execute a pipeline that executes a

mapping data low. and then inserts the data into the data warehouse.

Does this meet the goal?

Become a Premium Member for full access

Unlock Premium Member

Microsoft DP-203 Practice Test 8

Question

Microsoft DP-203 Practice Tests

Practice Tests