How many Drag and Drop Ordering Questions questions are on this page?

This page has 12 Drag and Drop Ordering Questions scenario questions for the DP-900 exam, each with detailed explanations and wrong-answer analysis.

How should I approach DP-900 scenario questions?

Read the full scenario before looking at the answer options. Identify the constraint or requirement in the scenario, then eliminate options that are generally true but wrong for this specific case. Scenario questions reward careful reading over pattern matching.

← Back to Microsoft Azure Data Fundamentals DP-900 questions

Scenario-based practice

Drag and Drop Ordering Questions

Practise Microsoft Azure Data Fundamentals DP-900 practice questions — original exam-style scenarios covering every exam domain, with detailed explanations, wrong-answer analysis, and common exam traps.

Start full practice test Read exam guide

scenario questions

DP-900

exam code

Microsoft

vendor

Scenario guide

How to approach drag and drop ordering questions

Drag-and-drop ordering questions ask you to arrange steps, commands, or events into the correct sequence. They test procedural knowledge — can you execute a Cisco IOS configuration task in the right order? These appear across Cisco, CompTIA, AWS, and Microsoft exams.

Quick answer

Drag and Drop Ordering Questions questions test whether you can apply the concept in context, not just recognise a definition.

How the topic appears in realistic exam-style scenarios.

Which detail in the question changes the correct answer.

How to eliminate plausible but wrong options.

How to connect the question back to the wider exam objective.

Practice scenarios

Question 1mediumdrag order

Full question →

A data engineering team is designing an ELT (Extract, Load, Transform) pipeline using Azure Data Lake Storage Gen2. They will ingest raw sales data from multiple sources, store it in the data lake, transform it using Azure Databricks, and finally store the transformed data in a curated zone for analytics. Place the steps in the correct order for an ELT pipeline.

A
Ingest raw data from sources
This is the first step in the ELT pipeline: extracting data from source systems.
B
Store raw data in Azure Data Lake Storage Gen2
This is the second step: loading the raw data into the data lake (the 'L' in ELT).
C
Transform data using Azure Databricks
This is the third step: applying transformations on the raw data (the 'T' in ELT).
D
Write transformed data to curated zone
This is the final step: storing the processed data in a structured, query-optimized format for analytics.

Full breakdown with real-world context →

Question 2mediumdrag order

Full question →

Drag and drop the steps to load data into Azure Synapse Analytics using PolyBase in the correct order.

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps

Order

1Step 1

2Step 2

3Step 3

4Step 4

5Step 5

Question 3mediumdrag order

Full question →

Drag and drop the steps to configure a geo-replication for Azure Cosmos DB in the correct order.

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps

Order

1Step 1

2Step 2

3Step 3

4Step 4

5Step 5

Question 4mediumdrag order

Full question →

Drag and drop the steps to ingest data into Azure Data Explorer (ADX) in the correct order.

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps

Order

1Step 1

2Step 2

3Step 3

4Step 4

5Step 5

Question 5mediumdrag order

Full question →

Drag and drop the steps to create an Azure Stream Analytics job in the correct order.

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps

Order

1Step 1

2Step 2

3Step 3

4Step 4

5Step 5

Question 6harddrag order

Full question →

A retail company needs to build an analytics pipeline on Azure. They ingest sales data from multiple store systems and an online e-commerce platform. The data must be cleaned, transformed, and loaded into a data warehouse for reporting. The company wants to use a modern ELT (Extract, Load, Transform) approach where raw data is stored first and then transformed. Order the following steps in the correct sequence for this pipeline. (Drag the steps into the correct order.)

A
Ingest data from sources using Azure Data Factory.
Data ingestion is the first step to bring raw data into Azure.
B
Store raw data in Azure Data Lake Storage Gen2.
Raw data is stored in a data lake for persistence and to enable schema-on-read.
C
Transform and clean data using Azure Databricks or Synapse Spark.
Transformations are applied after data is stored, which is characteristic of ELT.
D
Load transformed data into Azure Synapse Analytics dedicated SQL pool.
The curated data is loaded into a relational data warehouse for efficient querying.
E
Build Power BI reports on top of Azure Synapse Analytics.
Reporting is the final step, consuming the data warehouse for dashboards.

Full breakdown with real-world context →

Question 7mediumdrag order

Full question →

Drag and drop the steps to configure a firewall rule for Azure SQL Database in the correct order.

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps

Order

1Step 1

2Step 2

3Step 3

4Step 4

5Step 5

Question 8harddrag order

Full question →

A company is building a modern data warehouse on Azure using a lakehouse approach. Arrange the following steps in the correct order to implement a typical pipeline that starts with raw data ingestion and ends with business reporting.

A
Ingest raw data from various sources into Azure Data Lake Storage Gen2
This is the first step, establishing the bronze layer with raw ingested data.
B
Transform and clean data using Azure Synapse Pipelines or Azure Databricks
This is the second step, processing raw data into cleaned and structured datasets (silver/gold layers).
C
Load the transformed data into Azure Synapse Analytics dedicated SQL pool
This is the third step, moving refined data into the data warehouse for efficient querying.
D
Create interactive reports and dashboards using Power BI
This is the final step, enabling business users to visualize and analyze the data.

Full breakdown with real-world context →

Question 9mediumdrag order

Full question →

Drag and drop the steps to create an Azure Data Lake Storage Gen2 account in the correct order.

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps

Order

1Step 1

2Step 2

3Step 3

4Step 4

5Step 5

Question 10mediumdrag order

Full question →

Drag and drop the steps to perform a point-in-time restore of an Azure SQL Database in the correct order.

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps

Order

1Step 1

2Step 2

3Step 3

4Step 4

5Step 5

Question 11mediumdrag order

Full question →

A data engineering team wants to build a batch analytics pipeline. The raw data is stored in Azure Data Lake Storage Gen2 (ADLS Gen2). The final output will be a set of tables in Azure Synapse Analytics (dedicated SQL pool) that will be used to create reports in Power BI. Arrange the following steps in the correct order for a typical ETL process.

A
Ingest raw data from ADLS Gen2 into Azure Databricks for transformation using Azure Data Factory pipelines
Azure Data Factory orchestrates the pipeline, copying data from ADLS Gen2 to the transformation layer (Databricks) as the first step.
B
Transform the data using Azure Databricks (e.g., cleansing, aggregating, joining)
After ingestion, the data is processed in Databricks using Spark to perform transformations.
C
Load the transformed data into Azure Synapse Analytics dedicated SQL pool
The cleansed and aggregated data is then loaded into the data warehouse for efficient querying.
D
Create Power BI reports connected to Azure Synapse Analytics
Finally, Power BI connects to the data warehouse to build interactive dashboards and reports.

Full breakdown with real-world context →

Question 12mediumdrag order

Full question →

Drag and drop the steps to create an Azure SQL Database in the correct order.

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps

Order

1Step 1

2Step 2

3Step 3

4Step 4

5Step 5

These DP-900 practice questions are part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style DP-900 questions with detailed explanations, topic-based practice, mock exams, readiness tracking, and study analytics.

Drag and Drop Ordering Questions

How to approach drag and drop ordering questions

Quick answer

Related DP-900 topic practice pages

Describe core data concepts practice questions

Describe an analytics workload on Azure practice questions

Identify considerations for relational data on Azure practice questions

Describe considerations for working with non-relational data on Azure practice questions

DP-900 fundamentals practice questions

DP-900 scenario practice questions

DP-900 troubleshooting practice questions

Practice scenarios

Drag and drop the steps to load data into Azure Synapse Analytics using PolyBase in the correct order.

Drag and drop the steps to configure a geo-replication for Azure Cosmos DB in the correct order.

Drag and drop the steps to ingest data into Azure Data Explorer (ADX) in the correct order.

Drag and drop the steps to create an Azure Stream Analytics job in the correct order.

Drag and drop the steps to configure a firewall rule for Azure SQL Database in the correct order.

A company is building a modern data warehouse on Azure using a lakehouse approach. Arrange the following steps in the correct order to implement a typical pipeline that starts with raw data ingestion and ends with business reporting.

Drag and drop the steps to create an Azure Data Lake Storage Gen2 account in the correct order.

Drag and drop the steps to perform a point-in-time restore of an Azure SQL Database in the correct order.

Drag and drop the steps to create an Azure SQL Database in the correct order.