Skip to Content

Microsoft DP-203: Azure Data Factory Activities for Executing Stored Procedures

By: Author Alex Lim

Posted on

Categories Exam

Discover the two types of Azure Data Factory activities that can execute stored procedures and store column values as pipeline variables for the DP-203 certification exam.

Table of Contents

Question

You have an Azure SQL database named DB1 and an Azure Data Factory data pipeline named pipeline1.

From Data Factory, you configure a linked service to DB1.

In DB1, you create a stored procedure named SP1. SP1 returns a single row of data that has four columns.

You need to add an activity to pipeline1 to execute SP1. The solution must ensure that the values in the columns are stored as pipeline variables.

Which two types of activities can you use to execute SP1? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A. Script
B. Copy
C. Lookup
D. Stored Procedure

Answer

C. Lookup
D. Stored Procedure

Explanation

The two types of activities in Azure Data Factory that can execute the stored procedure SP1 and store the column values as pipeline variables are:

C. Lookup Activity

  • Lookup activity can retrieve data from various sources, including Azure SQL Database, and store the results in pipeline variables.
  • It supports executing stored procedures and can return up to 5000 rows.
  • The column values from the single row returned by SP1 can be easily mapped to pipeline variables using the Lookup activity.

D. Stored Procedure Activity

  • Stored Procedure activity is specifically designed to execute stored procedures in Azure SQL Database and Azure Synapse Analytics.
  • It allows you to directly specify the stored procedure name and input parameters.
  • The activity can capture the output of the stored procedure, including multiple result sets, and store them as pipeline variables.

Both Lookup and Stored Procedure activities provide complete solutions for executing SP1 and storing the column values as pipeline variables in the Azure Data Factory pipeline.

Data Engineering on Microsoft Azure DP-203 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Data Engineering on Microsoft Azure DP-203 exam and earn Data Engineering on Microsoft Azure DP-203 certification.