Microsoft DP-203 dumps - 100% Pass Guarantee!

You need to trigger an Azure Data Factory pipeline when a file arrives in an Azure Data Lake Storage Gen2 container. Which resource provider should you enable?

A. Microsoft.Sql

B. Microsoft.Automation

C. Microsoft.EventGrid

D. Microsoft.EventHub

You have a SQL pool in Azure Synapse.

A user reports that queries against the pool take longer than expected to complete.

You need to add monitoring to the underlying storage to help diagnose the issue.

Which two metrics should you monitor? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A. Cache used percentage

B. DWU Limit

C. Snapshot Storage Size

D. Active queries

E. Cache hit percentage

You have an Azure data factory.

You need to examine the pipeline failures from the last 180 flays.

What should you use?

A. the Activity tog blade for the Data Factory resource

B. Azure Data Factory activity runs in Azure Monitor

C. Pipeline runs in the Azure Data Factory user experience

D. the Resource health blade for the Data Factory resource

You have an Azure data factory named ADF1.

You currently publish all pipeline authoring changes directly to ADF1.

You need to implement version control for the changes made to pipeline artifacts. The solution must ensure that you can apply version control to the resources currently defined in the UX Authoring canvas for ADF1.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A. From the UX Authoring canvas, select Set up code repository.

B. Create a Git repository.

C. Create a GitHub action.

D. Create an Azure Data Factory trigger.

E. From the UX Authoring canvas, select Publish.

F. From the UX Authoring canvas, run Publish All.

You have an Azure Databricks workspace and an Azure Data Lake Storage Gen2 account named storage!

New files are uploaded daily to storage1.

Incrementally process new files as they are upkorage1 as a structured streaming source. The solution must meet the following requirements:

Minimize implementation and maintenance effort.

Minimize the cost of processing millions of files.

Support schema inference and schema drift.

Which should you include in the recommendation?

A. Auto Loader

B. Apache Spark FileStreamSource

C. COPY INTO

D. Azure Data Factory