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

Integration Runtime is the compute infrastructure Azure Data Factory uses to run activities, providing data movement, data transformation, and SSIS package execution capabilities.

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

Self-hosted Integration Runtime is installed on on-premises or cloud VMs in a private network, allowing Azure Data Factory to reach data sources not exposed to the public internet.

Question 3

What do Linked Services represent in Azure Data Factory?

Accepted Answer

Connection strings and authentication details for external data stores

Answer

Linked Services in Azure Data Factory function like connection strings, storing the endpoint and credentials required to connect ADF to external data sources and compute resources.

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

Schedule triggers fire pipelines based on wall-clock time on a recurring basis (e.g., daily, weekly), making them suitable for time-based batch workloads.

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

Mapping Data Flow lets you visually design data transformations using a graph-based UI; ADF compiles these flows into Spark jobs that run on an auto-managed Spark cluster.

DP-200 - Microsoft Azure Data Solutions Practice Test

DP-200 - Microsoft Azure Data Solutions Practice Test

DP-200 Azure Data Integration and Migration 2