A pipeline has a Notebook activity that processes data for a specific date. The date is stored in a pipeline variable. The notebook needs to receive the date as a parameter. How should the pipeline pass the variable to the notebook?

Hardcode the date in the notebook activity's parameters

Use a Dataflow Gen 2 to pass the variable to the notebook

Write the date to a file and have the notebook read it

Set the notebook activity's base parameters to reference the pipeline variable using a dynamic expression

A pipeline has a variable `fileName` that is set by a previous activity. The pipeline then calls a notebook that needs to use this variable. How should the pipeline pass the variable to the notebook?

Hardcode the file name in the notebook activity

Use a dynamic expression in the notebook activity's base parameters to reference the variable

Use a Dataflow Gen 2 to pass the variable

Write the variable to a file and have the notebook read it

A team needs to build a solution that ingests data from a REST API, performs complex transformations using a custom Python library, and loads the result to a Lakehouse. The team also needs to orchestrate this process with other pipelines. What is the best approach?

Use a pipeline with a Notebook activity for ingestion and transformations, and schedule the pipeline.

Use a pipeline with a Copy activity for ingestion and a Dataflow Gen 2 for transformations.

Use a notebook for ingestion and transformations, and schedule it via a pipeline.

Use a Dataflow Gen 2 for ingestion and transformations, and schedule it directly.

A pipeline needs to process files that arrive in a folder with a date-based naming convention, such as `sales_2024-01-15.csv`. The pipeline should process the file for the current date at runtime. What is the most efficient way to configure the pipeline?

Use a notebook activity that reads the current date from the system clock

Use a Dataflow Gen 2 that automatically detects the current date

Use a pipeline parameter for the date and set its default value to the current date using a dynamic expression

Create a new pipeline for each day with the date hardcoded

What is the purpose of a schedule in Microsoft Fabric data orchestration?

To define the order of activities within a pipeline

To automatically start a pipeline or dataflow at a specified time or interval

To monitor the performance of data processes

To manually run a pipeline on demand

Microsoft Certified:Fabric Data Engineer Associate

Domain 1Objective 4

Orchestrate Processes DP-700 Practice Questions (Page 5)

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 21–25

21application · medium
A pipeline has a Notebook activity that processes data for a specific date. The date is stored in a pipeline variable. The notebook needs to receive the date as a parameter. How should the pipeline pass the variable to the notebook?
Select an answer first
22application · medium
A pipeline has a variable `fileName` that is set by a previous activity. The pipeline then calls a notebook that needs to use this variable. How should the pipeline pass the variable to the notebook?
Select an answer first
23expert · hard
A team needs to build a solution that ingests data from a REST API, performs complex transformations using a custom Python library, and loads the result to a Lakehouse. The team also needs to orchestrate this process with other pipelines. What is the best approach?
Select an answer first
24application · medium
A pipeline needs to process files that arrive in a folder with a date-based naming convention, such as `sales_2024-01-15.csv`. The pipeline should process the file for the current date at runtime. What is the most efficient way to configure the pipeline?
Select an answer first
25foundation · easy
What is the purpose of a schedule in Microsoft Fabric data orchestration?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back 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.