Exam DP-700 Topic 1 Question 30 Discussion

Actual exam question for Microsoft's DP-700 exam
Question #: 30
Topic #: 1
You have a Fabric warehouse named DW1 that loads data by using a data pipeline named Pipeline1. Pipeline1 uses a Copy data activity with a dynamic SQL source. Pipeline1 is scheduled to run every 15 minutes.
You discover that Pipeline1 keeps failing.
You need to identify which SQL query was executed when the pipeline failed.
What should you do?

Suggested Answer: B Vote an answer

The input JSON contains the configuration details and parameters passed to the Copy data activity during execution, including the dynamically generated SQL query.
Viewing the input JSON for the failed pipeline run provides direct insight into what query was executed at the time of failure.

by Cheryl at Jan 18, 2025, 05:03 AM

Limited Time Offer

15%

Off

Get Premium DP-700 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
seseram110
2025-08-27 01:27:56
Answer A
According to Microsoft's documentation on monitoring pipeline runs in Fabric, the Output JSON of a failed activity (like Copy data) includes the error details and the command sent to the source (e.g., the dynamic SQL query).
upvoted 2 times
...
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.
0
0
0
10