Exam DP-600 topic 1 question 83 discussion

I took the test today, and this question was included. The options were: Switch, Copy Activity, Script, and Stored Procedure. I chose Script.

Lookup activity reads and returns the content of a configuration file or table. It also returns the result of executing a query or stored procedure. The output can be a singleton value or an array of attributes, which can be consumed in a subsequent copy, transformation, or control flow activities like ForEach activity. https://learn.microsoft.com/en-us/azure/data-factory/control-flow-lookup-activity

Script or Lookup activity https://learn.microsoft.com/en-us/fabric/data-factory/lookup-activity https://blog.fabric.microsoft.com/id-id/blog/automate-fabric-data-warehouse-queries-and-commands-with-data-factory?ft=All

Script -> https://learn.microsoft.com/en-us/fabric/data-factory/tutorial-preprocess-data-with-stored-procedure-load-into-lakehouse

Stored proc would be the answer

Lookup activity reads and returns the content of a configuration file or table. It also returns the result of executing a query or stored procedure. The output can be a singleton value or an array of attributes, which can be consumed in a subsequent copy, transformation, or control flow activities like ForEach activity. the quote from https://learn.microsoft.com/en-us/fabric/data-factory/lookup-activity so I suppose the answer is correct. But why Append variable isn't correct?

The correct answer is D

https://learn.microsoft.com/en-us/azure/data-factory/tutorial-pipeline-failure-error-handling Upon Success: (Default Pass) Execute this path if the current activity succeeded Upon Failure: Execute this path if the current activity failed Upon Completion: Execute this path after the current activity completed, regardless if it succeeded or not Upon Skip: Execute this path if the activity itself didn't run

https://pragmaticworks.com/blog/azure-data-factory-lookup-and-stored-procedure

I'd say D

it`s strange, because there is activity stored proc in fabric pipes.

Correct

ANS D - Lookup