DP-900 Describe an analytics workload on Azure Practice Question
Exhibit
Refer to the exhibit.
{
"name": "sales-pipeline",
"properties": {
"activities": [
{
"name": "CopySalesData",
"type": "Copy",
"inputs": [{"referenceName": "SalesOnPrem", "type": "DatasetReference"}],
"outputs": [{"referenceName": "SalesAzureSQL", "type": "DatasetReference"}],
"typeProperties": {
"source": {
"type": "SqlServerSource",
"sqlReaderQuery": "SELECT * FROM Sales WHERE OrderDate >= '2023-01-01'"
},
"sink": {
"type": "SqlSink",
"writeBatchSize": 10000
}
}
}
]
}
}Refer to the exhibit. An Azure Data Factory pipeline JSON is shown. What does this pipeline do?
⚠ Common exam trap
The trap here is that candidates often overlook the WHERE clause in the source query and assume the pipeline copies all data, or they confuse the direction of data movement between on-premises and Azure.
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
✓
Copies filtered sales data from on-premises to Azure SQL Database
The pipeline uses a Copy activity with a source dataset pointing to an on-premises SQL Server (via a self-hosted integration runtime) and a sink dataset pointing to an Azure SQL Database. The source query includes a WHERE clause filtering sales data by a date range, so only filtered data is copied. This matches option C.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Copies sales data from Azure SQL Database to on-premises
Why it's wrong here
This option inverts the actual data flow: the JSON's copy activity defines an on-premises source (such as SQL Server behind an integration runtime) and an Azure SQL Database sink. The pipeline reads from the on-premises database and writes to Azure SQL, not the other way around. Therefore, the direction is reversed, making the answer incorrect.
- ✗
Copies all sales data from on-premises to Azure SQL Database
Why it's wrong here
The pipeline's copy activity does not transfer the entire on-premises sales table. The JSON includes a source query with a WHERE clause that restricts rows to sales from 2023 onwards, so only a filtered subset of records is copied. Consequently, describing it as copying 'all' sales data is inaccurate, even though the source and sink are otherwise correct.
- ✓
Copies filtered sales data from on-premises to Azure SQL Database
Why this is correct
This accurately describes the pipeline's copy activity: the source dataset points to an on-premises SQL Server source, the sink dataset points to an Azure SQL Database, and the source query uses a WHERE clause to filter sales records for 2023 onwards. Because the source-to-destination mapping and the presence of the filter are all reflected in the JSON, this is the correct choice.
- ✗
Copies sales data from on-premises to Azure Data Lake Storage
Why it's wrong here
This option misidentifies the sink. The JSON definition specifies Azure SQL Database as the destination for the copied data, not Azure Data Lake Storage. Azure Data Lake Storage would be represented by a different sink dataset (for example, a DelimitedText or Parquet dataset in an ADLS Gen2 linked service), so this answer is incorrect.
Go deeper
Related to this question
Learn chapter
Data Roles and Core Concepts
Key term
Pipeline
A pipeline is an automated series of steps that takes code from development to production, ensuring quality and speed.
Key term
Azure SQL Database
Azure SQL Database is a fully managed relational database-as-a-service (DBaaS) in Microsoft Azure, based on the SQL Server engine, that handles scaling, backups, patching, and high availability automatically.
About these practice questions
This DP-900 question is part of Courseiva's 820-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-900 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-900 exam.