DP-200 Azure Data Processing and Pipelines 1 — Questions and Answers
Question 1: In Azure Data Factory, what is a pipeline?
- A cloud storage container
- A logical grouping of activities that perform a unit of work (Correct answer)
- A real-time stream processor
- A machine learning model deployment
Correct answer: A logical grouping of activities that perform a unit of work
An ADF pipeline is a logical grouping of activities—such as copy, transformation, or control flow—that together perform a data integration task.
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?
- Azure Integration Runtime
- Self-hosted Integration Runtime
- SSIS Integration Runtime
- Managed Virtual Network Integration Runtime (Correct answer)
Correct answer: Managed Virtual Network Integration Runtime
The Managed Virtual Network Integration Runtime runs within a managed VNet, providing secure connectivity to private data sources without public exposure.
Question 3: What is the purpose of a linked service in Azure Data Factory?
- To define transformation logic
- To store connection information for a data store or compute resource (Correct answer)
- To schedule pipeline triggers
- To monitor data quality
Correct answer: To store connection information for a data store or compute resource
A linked service in ADF defines the connection string and credentials needed to connect to an external data store or compute target.
Question 4: In Azure Data Factory, which trigger type executes a pipeline based on a defined schedule (e.g., daily at midnight)?
- Tumbling window trigger
- Schedule trigger (Correct answer)
- Event-based trigger
- Manual trigger
Correct answer: Schedule trigger
A schedule trigger fires a pipeline at a fixed wall-clock time or on a recurring schedule such as daily, weekly, or hourly.
Question 5: Which Azure Data Factory activity is used to copy data from a source dataset to a sink dataset?
- Lookup activity
- Copy activity (Correct answer)
- Execute Pipeline activity
- Web activity
Correct answer: Copy activity
The Copy activity is ADF's primary data ingestion mechanism, transferring data from a supported source to a supported sink.
Question 6: What does a tumbling window trigger in Azure Data Factory guarantee that a schedule trigger does not?
- Lower cost per execution
- Non-overlapping, contiguous time windows with retry on failure (Correct answer)
- Parallel execution of all windows simultaneously
- Automatic schema mapping
Correct answer: Non-overlapping, contiguous time windows with retry on failure
Tumbling window triggers process non-overlapping fixed-size time windows and automatically handle late arrivals and retries for each window.
DP-200 Azure Data Processing and Pipelines 1
In Azure Data Factory, what is a pipeline?