Describe an analytics workload on Azure →easyMultiple Choice

DP-900 Describe an analytics workload on Azure Practice Question

Exhibit

Refer to the exhibit.

```json
{
  "name": "CopyFromOnPrem",
  "properties": {
    "activities": [
      {
        "name": "CopyData",
        "type": "Copy",
        "inputs": [
          {
            "referenceName": "OnPremSqlServerDataset",
            "type": "DatasetReference"
          }
        ],
        "outputs": [
          {
            "referenceName": "AzureSqlDatabaseDataset",
            "type": "DatasetReference"
          }
        ],
        "typeProperties": {
          "source": {
            "type": "SqlSource",
            "sqlReaderQuery": "SELECT * FROM Sales.Orders WHERE OrderDate > '2025-01-01'"
          },
          "sink": {
            "type": "SqlSink",
            "writeBatchSize": 10000
          }
        }
      }
    ],
    "integrationRuntime": {
      "referenceName": "SelfHostedIR",
      "type": "IntegrationRuntimeReference"
    }
  }
}
```

Refer to the exhibit. You have created this Azure Data Factory pipeline. When you run it, the copy activity fails with a connectivity error. What is the most likely missing component?

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

✓

A self-hosted integration runtime is not installed on premises

The correct answer is B: a self-hosted integration runtime is not installed on premises. When Azure Data Factory must copy data to or from an on-premises SQL Server, the copy activity cannot reach it directly; it requires a self-hosted integration runtime installed on a machine in the on-premises network to act as the bridge, and its absence produces exactly this connectivity error. Option A is wrong because the Azure SQL Database firewall applies to Azure SQL Database, not to an on-premises SQL Server. Option C is wrong because an invalid SQL query would cause a query/syntax error, not a connectivity failure. Option D is wrong because exposing the on-premises SQL Server via a public endpoint is not the required or recommended solution; the self-hosted integration runtime is.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
The Azure SQL Database firewall must allow Azure services
Why it's wrong here
A firewall rule permitting Azure services addresses server-level network access, yet the copy activity fails at the linked service or dataset connection stage, so this is not the missing component. It is tempting because firewall blocking does cause connectivity errors, and this setting is correct when Azure-hosted services must reach a firewall-protected database.
✓
A self-hosted integration runtime is not installed on premises
Why this is correct
A self-hosted integration runtime bridges on-premises data stores and Azure Data Factory, executing copy activities on a machine inside your network. The connectivity failure indicates the source sits behind a firewall, so without this runtime installed locally, the cloud-hosted IR cannot reach it, satisfying the on-premises access constraint in the stem.
✗
The SQL query is invalid
Why it's wrong here
An invalid SQL query produces a query execution or syntax error, not a connectivity error, so it cannot be the missing component. It is tempting because query faults also fail copy activities, but this would be correct when the pipeline connects successfully and then returns malformed statement errors.
✗
The on-premises SQL Server must have a public endpoint
Why it's wrong here
Exposing a public endpoint on the on-premises SQL Server contradicts secure hybrid connectivity and does not supply the missing component; Data Factory reaches on-premises sources through a self-hosted integration runtime. It is tempting because public endpoints do enable access, and this is correct only when no private network path exists.

Go deeper

DP-900 Describe an analytics workload on Azure Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question