What is a common orchestration pattern when using notebooks in a pipeline?

Using a notebook to store data in a relational database

Using a notebook to directly trigger other notebooks without a pipeline

Using a notebook to create a Power BI report

Using a notebook activity in a pipeline to run a notebook with specific parameters

A company has a pipeline that must run at 2:00 AM every Monday to process the previous week's data. The pipeline takes about 30 minutes to complete. What schedule should the data engineer configure?

A monthly schedule on the first Monday at 2:00 AM

A schedule that runs every 30 minutes from 2:00 AM to 2:30 AM on Mondays

A weekly schedule on Monday at 2:00 AM

A pipeline has a Copy activity that loads data from a source. The team wants to conditionally run a subsequent transformation only if the copy activity succeeded and the row count is greater than zero. What is the best way to implement this?

Use a notebook to check the row count and then call the pipeline.

Use a Dataflow Gen 2 to check the row count and trigger the transformation.

Use the 'On success' completion condition of the Copy activity and add a conditional activity that checks the row count.

Use the 'On completion' condition and let the transformation run regardless of success.

Microsoft Certified:Fabric Data Engineer Associate

Domain 1Objective 4

Orchestrate Processes DP-700 Practice Questions (Page 8)

Part of the Implement and manage an analytics solution domain, which accounts for 30–35% of the DP-700 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~12–23 in this domain), expect 3–6 from this objective — we provide 39 practice questions to prepare you well beyond it. (estimate)

39questions here

8free pages

9concepts

30–35%of the exam

Questions 36–39

36foundation · easy
What is a common orchestration pattern when using notebooks in a pipeline?
Select an answer first
37foundation · easy
A data engineer needs to run a complex data transformation that requires custom Python libraries and iterative development. Which tool is most appropriate?
Select an answer first
38application · easy
A company has a pipeline that must run at 2:00 AM every Monday to process the previous week's data. The pipeline takes about 30 minutes to complete. What schedule should the data engineer configure?
Select an answer first
39application · medium
A pipeline has a Copy activity that loads data from a source. The team wants to conditionally run a subsequent transformation only if the copy activity succeeded and the row count is greater than zero. What is the best way to implement this?
Select an answer first

Finished these 4 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to DP-700

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-700” is a trademark of its owner, used for identification only.

Orchestrate Processes DP-700 Practice Questions (Page 8)

Questions 36–39

What is a common orchestration pattern when using notebooks in a pipeline?

A data engineer needs to run a complex data transformation that requires custom Python libraries and iterative development. Which tool is most appropriate?

A company has a pipeline that must run at 2:00 AM every Monday to process the previous week's data. The pipeline takes about 30 minutes to complete. What schedule should the data engineer configure?

A pipeline has a Copy activity that loads data from a source. The team wants to conditionally run a subsequent transformation only if the copy activity succeeded and the row count is greater than zero. What is the best way to implement this?

Keep studying — Implement and manage an analytics solution