exam questions

Exam DP-700 All Questions

View all questions & answers for the DP-700 exam

Exam DP-700 topic 1 question 52 discussion

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

You are building a Fabric notebook named MasterNotebook1 in a workspace. MasterNotebook1 contains the following code.



You need to ensure that the notebooks are executed in the following sequence:

1. Notebook_03
2. Notebook_01
3. Notebook_02

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

  • A. Move the declaration of Notebook_02 to the bottom of the Directed Acyclic Graph (DAG) definition.
  • B. Add dependencies to the execution of Notebook_03.
  • C. Split the Directed Acyclic Graph (DAG) definition into three separate definitions.
  • D. Add dependencies to the execution of Notebook_02.
  • E. Change the concurrency to 3.
  • F. Move the declaration of Notebook_03 to the top of the Directed Acyclic Graph (DAG) definition.
Show Suggested Answer Hide Answer
Suggested Answer: DF 🗳️

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
e392998
1 week, 5 days ago
Selected Answer: F
1) Concurrencies is set to 0 meaning the order of the activities will be respected even without dependencies. 2) you just have to be sure the order is set correctly so moving 3 on top
upvoted 1 times
...
cabe9c7
2 weeks, 2 days ago
Selected Answer: AB
Their is something seriously wrong with this question. I think their are 2 mistakes in the question itself. First of all their are 2 definitions for notebook 3. Secondly, the answers have a mistake where their should be a dependency on Notebook 3 and Notebook 1. Not Notebook 3 and Notebook 2.
upvoted 1 times
...
ca_acc
1 month, 2 weeks ago
Selected Answer: D
I'm sorry, the responses are wrongly worded. We need to set dependencies within 01 und 02 and not within 03. Actully only D should be right IMO. This answer options ar weired.
upvoted 1 times
cabe9c7
2 weeks, 2 days ago
Their is something seriously wrong with this question. I think their are 2 mistakes in the question itself. First of all their are 2 definitions for notebook 3. Secondly, the answers have a mistake where their should be a dependency on Notebook 3 and Notebook 1. Not Notebook 3 and Notebook 2.
upvoted 1 times
...
...
e35e079
1 month, 3 weeks ago
Selected Answer: BD
Explanation: To enforce the required sequence: Set Notebook_03 to execute first (no dependencies needed). Then set Notebook_01 to depend on Notebook_03. Then set Notebook_02 to depend on Notebook_01. This is achieved by adding the "dependsOn" key to each not
upvoted 2 times
...
Stef6108
2 months ago
Selected Answer: BD
The execution order in a DAG is only ensured by dependencies, not the position in the defining data structure (JSON).
upvoted 2 times
Stef6108
2 months ago
Wrong, ignore.
upvoted 2 times
...
...
smanzana
2 months ago
Selected Answer: BD
BD is correct
upvoted 1 times
...
moons_123
2 months, 1 week ago
Selected Answer: DF
D,F - Concurrency set to 0 means they will start all at once. So add dependencies and change the order. https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/microsoft-spark-utilities?pivots=programming-language-python#reference-run-multiple-notebooks-in-parallel
upvoted 4 times
...
Sr18
2 months, 3 weeks ago
Selected Answer: BD
Why BD is best answer: Sequence of activity declaration wont matter till the time you have dependencies written for Notebook1 in Notebook 03, and Notebook 02 dependency on Notebook 01. So no need to move notebook 03 on top
upvoted 2 times
Sr18
2 months, 3 weeks ago
Another thing they will execute in parallel if there are no dependencies mentioned.
upvoted 1 times
Sr18
2 months, 3 weeks ago
DF: Finally after long thinking and being lost in verbiage. Concurrency is set to 0: They will start executing all together So best option is to move notebook 3 on top Add dependency to notebook 2. But this will still not solve the problem, as we need to add dependency in Notebook1 for notebook 2, or change concurrency to 1. And moreover delete the duplication of notebook 3 execution. So overall this question is either stupid or wrong options are mentioned. Does not make sense at all. Whatever you choose from here it will never work.
upvoted 3 times
...
...
...
8d1e8fe
3 months ago
Selected Answer: F
What am i missing here? Why is notebook_03 mentioned twice? Also moving Notebook_03 to the top already solves the entire problem since the concurrency is set to 1. There is no need to add a dependency for execution order since 1 and 2 are already ordered correctly.
upvoted 3 times
...
kim32
3 months, 1 week ago
Selected Answer: BD
Why Not Other Options? A/F (Moving declarations): Order in the DAG array doesn’t control execution sequence; dependencies do. C (Splitting DAG): Unnecessary; a single DAG with dependencies works. E (Concurrency=3): Irrelevant for sequential execution (use concurrency=1 if strict order is needed).
upvoted 2 times
...
AnetaK
3 months, 3 weeks ago
Selected Answer: DF
Why is Notebook_03 listed two times in the code?
upvoted 1 times
...
5e89616
4 months, 1 week ago
Selected Answer: DF
I would also add dependencies to Notebook_01 but it was not listed
upvoted 4 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 ...