DP-900 Drag & Drop — 10 Questions

Question 1

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.

Accepted Answer

Ingest raw data from sources. In an ELT pipeline, data is first extracted and loaded into the data lake, then transformed. This order follows the ELT paradigm: extract, load, transform.

Question 2

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

Question 3

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

Question 4

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

Question 5

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

Question 6

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.)

Accepted Answer

Ingest data from sources using Azure Data Factory.. ELT approach first ingests raw data to storage, loads it into the warehouse, then transforms it before creating reporting structures.

Question 7

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

Question 8

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.

Accepted Answer

Ingest raw data from various sources into Azure Data Lake Storage Gen2. The lakehouse pipeline starts with raw data ingestion, followed by transformation and loading into a curated layer, then creating tables for querying, and finally reporting with Power BI.

Question 9

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

Question 10

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