DP-203 Develop data processing Practice Question
Exhibit
{
"type": "Microsoft.Synapse/workspaces/integrationRuntimes",
"apiVersion": "2021-06-01-preview",
"properties": {
"type": "SelfHosted",
"description": "Integration runtime for on-premises data sources"
}
}Refer to the exhibit. You are reviewing an ARM template snippet for an Azure Synapse Analytics workspace. The template defines an integration runtime. A colleague asks whether this integration runtime can be used to copy data from an on-premises SQL Server database to Azure Blob Storage. What should you answer?
⚠ Common exam trap
Many candidates confuse the self-hosted IR with the Azure IR, assuming any IR can access on-premises data, but only the self-hosted IR (installed locally) can bridge the on-premises-to-cloud gap.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Yes, because the integration runtime is self-hosted and can access on-premises data sources.
The ARM template snippet defines a self-hosted integration runtime, which is designed to be installed on a local machine inside the corporate network. This allows it to directly connect to on-premises SQL Server databases using native drivers (e.g., ADO.NET) and then copy data to Azure Blob Storage via the Azure cloud. Self-hosted IRs are the correct choice for hybrid data movement scenarios where the source is on-premises and the destination is cloud-based.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
No, you need an Azure integration runtime that is configured for on-premises access.
Why it's wrong here
Azure IR cannot access on-premises sources directly.
- ✓
Yes, because the integration runtime is self-hosted and can access on-premises data sources.
Why this is correct
Self-hosted IR is used for on-premises/private network data sources.
- ✗
No, you need a managed virtual network integration runtime for on-premises sources.
Why it's wrong here
Managed VNet IR is for Azure data sources behind a VNet, not on-premises.
- ✗
Yes, but only if the integration runtime is installed on a domain-joined machine.
Why it's wrong here
Domain join is not a requirement; the IR only needs network access to the source.
Quick reference
Azure Blob Storage Tier Comparison
| Tier | Storage Cost | Retrieval Cost | Latency | Use Case |
|---|---|---|---|---|
| Hot | Highest | Lowest | Immediate | Active data, frequent reads |
| Cool | Lower | Higher | Immediate | Data accessed < once / month |
| Cold | Lower still | Higher | Immediate | Data accessed < once / quarter |
| Archive | Lowest | Highest + rehydration delay | Hours | Long-term compliance retention |
Go deeper
Related to this question
About these practice questions
This DP-203 question is part of Courseiva's 760-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-203 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-203 exam.