exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam

Exam DP-700 topic 1 question 53 discussion

Actual exam question from Microsoft's DP-700
Question #: 53
Topic #: 1
[All DP-700 Questions]

You have a Fabric workspace that contains a data pipeline named Pipeline1 as shown in the exhibit. (Click the Exhibit tab.)



What will occur the next time Pipeline1 runs?

  • A. Copy_kdi will run first, and then Execute procedure1 will run.
  • B. Execute procedure1 will run first, and then Copy_kdi will run.
  • C. Execute procedure1 will run and Copy_kdi will be skipped.
  • D. Copy_kdi will run and Execute procedure1 will be skipped.
  • E. Both activities will run simultaneously.
  • F. Both activities will be skipped.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
f6f3e50
2 days, 1 hour ago
Selected Answer: D
Here's what happens: If one activity (e.g., a Copy activity) is active and connected, and another (like a Stored Procedure activity) is inactive and unconnected, only the active one runs. Inactive activities do not execute, just like in Azure Data Factory. Unconnected activities are not part of the execution graph, so Fabric does not trigger them.
upvoted 1 times
...
Tamele001
1 week ago
Selected Answer: E
Both activities will run simultaneously. The Execute procedure1 activity was inactive in the previous run, it does not mean that on the next one it will inactive again. There's no way of disabling an activity
upvoted 1 times
...
12a2ecc
2 weeks, 4 days ago
Selected Answer: E
Is that just the history showing inactive for copy_kdi? Isn't it active on the diagram? I was thinking they would both run(E)
upvoted 1 times
12a2ecc
2 weeks, 4 days ago
I incorrectly viewed this originally; D does look correct since the Stored Proc step appears disabled in the pipeline
upvoted 1 times
...
...
5e89616
3 weeks, 2 days ago
Selected Answer: D
(D) Copy_kdi will run and Execute procedure1 will be skipped (because it's inactive). I do not see why both would be skipped?...
upvoted 1 times
5e89616
3 weeks, 2 days ago
or (E) Both would run simultaneously, even thou Stored Procedure is inactive
upvoted 1 times
12a2ecc
2 weeks, 4 days ago
Is that just the history showing inactive for copy_kdi? Isn't it active on the diagram? I was thinking they would both run(E)
upvoted 1 times
...
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago