DP-200 Azure Data Integration and Migration 2

Question 1

What is the role of Integration Runtime (IR) in Azure Data Factory?

Accepted Answer

To provide the compute infrastructure that executes data integration activities

Answer

To store pipeline definitions and metadata

Answer

To schedule pipeline triggers at defined intervals

Answer

To generate reports on data lineage

Question 2

Which type of Azure Data Factory Integration Runtime must be installed on an on-premises machine to access private network data sources?

Accepted Answer

Self-hosted Integration Runtime

Answer

Azure Integration Runtime

Answer

Azure-SSIS Integration Runtime

Answer

Hybrid Integration Runtime

Question 3

What do Linked Services represent in Azure Data Factory?

Accepted Answer

Connection strings and authentication details for external data stores

Answer

Logical groupings of pipeline activities

Answer

References to datasets used across multiple pipelines

Answer

Scheduled trigger definitions

Question 4

Which Azure Data Factory trigger type fires pipelines on a recurring wall-clock schedule, such as every day at 8:00 AM UTC?

Accepted Answer

Schedule trigger

Answer

Tumbling window trigger

Answer

Storage event trigger

Answer

Custom event trigger

Question 5

Which Azure Data Factory feature provides a visually designed, code-free interface for building complex data transformation logic that runs on Spark?

Accepted Answer

Mapping Data Flow

Answer

Data Flow

Answer

Pipeline Editor

Answer

Copy Data wizard

Question 6

Which Azure Data Factory capability allows a single dataset definition to serve multiple data sources by accepting runtime-provided values?

Accepted Answer

Parameterization

Answer

Schema mapping

Answer

Linked service chaining

Answer

Dataset cloning

Question 7

In Azure Data Factory, which construct is a logical grouping of activities that together perform a unit of work?

Accepted Answer

Pipeline

Answer

Dataset

Answer

Linked Service

Answer

Trigger