DP-200 Azure Data Processing and Pipelines

Question 1

In Azure Data Factory, what is a pipeline?

Accepted Answer

A logical grouping of activities that perform a unit of work

Answer

A cloud storage container

Answer

A real-time stream processor

Answer

A machine learning model deployment

Question 2

Which Azure Data Factory integration runtime is used to execute activities within a private virtual network without exposing data to the public internet?

Accepted Answer

Managed Virtual Network Integration Runtime

Answer

Azure Integration Runtime

Answer

Self-hosted Integration Runtime

Answer

SSIS Integration Runtime

Question 3

What is the purpose of a linked service in Azure Data Factory?

Accepted Answer

To store connection information for a data store or compute resource

Answer

To define transformation logic

Answer

To schedule pipeline triggers

Answer

To monitor data quality

Question 4

In Azure Data Factory, which trigger type executes a pipeline based on a defined schedule (e.g., daily at midnight)?

Accepted Answer

Schedule trigger

Answer

Tumbling window trigger

Answer

Event-based trigger

Answer

Manual trigger

Question 5

Which Azure Data Factory activity is used to copy data from a source dataset to a sink dataset?

Accepted Answer

Copy activity

Answer

Lookup activity

Answer

Execute Pipeline activity

Answer

Web activity

Question 6

What does a tumbling window trigger in Azure Data Factory guarantee that a schedule trigger does not?

Accepted Answer

Non-overlapping, contiguous time windows with retry on failure

Answer

Lower cost per execution

Answer

Parallel execution of all windows simultaneously

Answer

Automatic schema mapping