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

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

Suggested Answer: DF 🗳️

by 5e89616 at April 8, 2025, 2:26 p.m.

Comments

Submit Cancel

Stef6108

1 week, 2 days 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 1 times

Stef6108

1 week, 2 days ago

Wrong, ignore.

upvoted 1 times

...

smanzana

1 week, 2 days ago

Selected Answer: BD

BD is correct

upvoted 1 times

...

moons_123

2 weeks, 4 days 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 2 times

...

Sr18

1 month 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

1 month ago

Another thing they will execute in parallel if there are no dependencies mentioned.

upvoted 1 times

Sr18

1 month 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 1 times

...

8d1e8fe

1 month, 2 weeks 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 1 times

...

kim32

1 month, 2 weeks 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

1 month, 4 weeks ago

Selected Answer: DF

Why is Notebook_03 listed two times in the code?

upvoted 1 times

...

5e89616

2 months, 3 weeks ago

Selected Answer: DF

I would also add dependencies to Notebook_01 but it was not listed

upvoted 3 times

...