Exam DP-600 topic 1 question 160 discussion

Actual exam question from Microsoft's DP-600

Question #: 160
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. Get metadata
B. Switch
C. Lookup
D. Append variable

Show Suggested Answer

Suggested Answer: C 🗳️

by MYPE at Feb. 12, 2025, 2:54 p.m.

Comments

Submit Cancel

Sr18

1 month, 1 week ago

Selected Answer: C

Lookup is for running SP

upvoted 1 times

...

tizian10

3 months, 2 weeks ago

Selected Answer: C

The Lookup activity is specifically designed to execute a query or stored procedure and retrieve a single value (or a small set of values) from a data source. The Lookup activity will allow you to execute your stored procedure that returns the required values (active customers and average sales). The results of the stored procedure can be captured into a variable, which can then be used by downstream activities in the pipeline.

upvoted 1 times

...

MYPE

4 months, 1 week ago

Selected Answer: C

this question comes many times

upvoted 1 times

...