Exam DP-600 topic 1 question 114 discussion

Actual exam question from Microsoft's DP-600

Question #: 114
Topic #: 1

You have a Fabric tenant.

You are creating a Fabric Data Factory pipeline.

You have a stored procedure that returns the number of active customers and their average sales for the current month.

You need to add an activity that will execute the stored procedure in a warehouse. The returned values must be available to the downstream activities of the pipeline.

Which type of activity should you add?

A. Switch
B. KQL
C. Append variable
D. Lookup

Show Suggested Answer

Suggested Answer: D 🗳️

by Pegooli at Oct. 10, 2024, 9:10 a.m.

Comments

Submit Cancel

nappi1

6 months, 1 week ago

Selected Answer: D

Lookup is correct

upvoted 1 times

...

2fe10ed

6 months, 3 weeks ago

Selected Answer: D

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

upvoted 2 times

...

nappi1

7 months, 2 weeks ago

Selected Answer: D

to execute a stored procedure in a Fabric Data Factory pipeline and make the returned values available for downstream activities, you should use the Lookup activity. the Lookup activity allows you to execute a query or stored procedure and retrieve the results, which can then be used in subsequent activities within the pipeline.

upvoted 2 times

...

Pegooli

8 months, 3 weeks ago

D is correct - A Lookup activity in Fabric Data Factory is specifically designed to execute a query or stored procedure and retrieve data from a data source.

upvoted 3 times

...