nerdexam
Microsoft

70-776 · Question #28

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. See the full explanation below for the reasoning.

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

(64 responses)
  • A
    8% (5)
  • B
    5% (3)
  • C
    16% (10)
  • D
    72% (46)

Community Discussion

No community discussion yet for this question.

Full 70-776 Practice