exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam

Exam DP-700 topic 3 question 8 discussion

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

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?

  • A. From Monitoring hub, select the latest failed run of Pipeline1, and then view the output JSON.
  • B. From Monitoring hub, select the latest failed run of Pipeline1, and then view the input JSON.
  • C. From Real-time hub, select Fabric events, and then review the details of Microsoft.Fabric.ItemReadFailed.
  • D. From Real-time hub, select Fabric events, and then review the details of Microsoft. Fabric.ItemUpdateFailed.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

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
GHill1982
Highly Voted 3 months, 4 weeks ago
Selected Answer: B
Correct the input JSON from the Copy data activity in the Pipeline will show the SQL query.
upvoted 8 times
...
Tuki93
Most Recent 2 months, 4 weeks ago
Selected Answer: B
Seems to be the correct answer.
upvoted 2 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