exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam

Exam DP-700 topic 1 question 42 discussion

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

DRAG DROP
-

You have two Fabric notebooks named Load_Salesperson and Load_Orders that read data from Parquet files in a lakehouse. Load_Salesperson writes to a Delta table named dim_salesperson. Load_Orders writes to a Delta table named fact_orders and is dependent on the successful execution of Load_Salesperson.

You need to implement a pattern to dynamically execute Load_Salesperson and Load_Orders in the appropriate order by using a notebook.

How should you complete the code? To answer, drag the appropriate values the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:

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
5e89616
Highly Voted 1 month, 1 week ago
Correct activities: to list the activities dependencies: to make sure the order and dependency of running runMultiple: there are 2 notebooks to be executed
upvoted 8 times
...
kim32
Most Recent 5 days, 16 hours ago
https://learn.microsoft.com/en-us/fabric/data-engineering/microsoft-spark-utilities#reference-run-multiple-notebooks-in-parallel
upvoted 1 times
...
Sunnyb
3 weeks ago
Correct answer should be: "notebooks" defines the list of notebook execution steps. "dependencies" specifies that Load_Orders depends on Load_Salesperson. mssparkutils.notebook.runMultiple() is the correct API call to execute a DAG of notebooks in Fabric. In Azure Data Factory and Synapse Pipelines, workflows use activities ...not in Fabric
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