You are creating a Data Factory workflow. The workflow must run a stored procedure from a SQL database, perform a Hive query, and copy data from an on-premises SQL database into an Azure SQL…

The correct answer is D. Pipeline. You should use a pipeline. A pipeline is used to configure several activities, including the sequence and timing. Activities in a pipeline can be managed as a unit. You should not use an activity. Although each step in this workflow is an activity, you must use a pipeline to…

Operationalize Big Data solutions

Question

You are creating a Data Factory workflow. The workflow must run a stored procedure from a SQL database, perform a Hive query, and copy data from an on-premises SQL database into an Azure SQL database. These steps must be managed and performed as an atomic unit. You need to configure the workflow. Which Data Factory entity should you use?

Options

ADataset
BLinked service
CActivity
DPipeline

How the community answered

(41 responses)

A
2% (1)
B
17% (7)
C
7% (3)
D
73% (30)

Explanation

You should use a pipeline. A pipeline is used to configure several activities, including the sequence and timing. Activities in a pipeline can be managed as a unit. You should not use an activity. Although each step in this workflow is an activity, you must use a pipeline to manage several activities as a unit. You should not use a dataset. A dataset defines metadata and points to the location of the actual data sources used by the Data Factory. You should not use a linked service. A linked service is a connection to a resource used by the

Topics

#Azure Data Factory#pipeline#atomic workflow#orchestration

Community Discussion

No community discussion yet for this question.

Full 70-475 Practice