ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam
Go to 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 🗳️
by GHill1982 at Jan. 1, 2025, 7:25 p.m.

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
Submit Cancel
GHill1982
Highly Voted 6 months ago
Selected Answer: B
Correct the input JSON from the Copy data activity in the Pipeline will show the SQL query.
upvoted 12 times
...
smanzana
Most Recent 2 weeks, 2 days ago
Selected Answer: B
B is correct
upvoted 1 times
...
gretito_g
3 weeks, 2 days ago
Selected Answer: B
When a pipeline in Microsoft Fabric (or Azure Data Factory, which shares many concepts) fails, you can diagnose the issue by examining the input and output JSON of the activity run. -The input JSON shows the configuration and parameters sent into the activity at runtime—including dynamic SQL queries that were resolved from expressions. -The output JSON shows the result or error returned after the activity was executed.
upvoted 1 times
...
DarioReymago
3 weeks, 5 days ago
Selected Answer: A
log message is shown in output
upvoted 2 times
exnaniantwort
3 weeks, 3 days ago
No, the question asks for "which SQL query" (input), not the query result (output)
upvoted 1 times
...
...
PBridge
1 month, 1 week ago
Selected Answer: A
From Monitoring hub, select the latest failed run of Pipeline1, and then view the output JSON.
upvoted 1 times
...
lapiscineeviden
1 month, 4 weeks ago
Selected Answer: A
Correct answer: A. From Monitoring hub, select the latest failed run of Pipeline1, and then view the output JSON. Lorsque tu exécutes une activité Copy data dans un pipeline Fabric, le query SQL dynamique réellement exécuté est généré et injecté par le runtime du pipeline au moment de l’exécution. Cette requête finale se retrouve dans le Output JSON, L’input JSON contient : Les paramètres d’entrée tels que configurés dans le pipeline (souvent avant résolution dynamique). Il ne montre pas nécessairement la requête SQL complète après substitution des variables ou expression dynamique. https://learn.microsoft.com/fr-fr/fabric/data-factory/monitor-pipeline-runs
upvoted 2 times
...
Tuki93
5 months 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