In a notebook, how can dynamic expressions be used to enhance orchestration?

By using Python variables and functions to compute values based on parameters or runtime context

By using a scheduling expression

By using a visual expression builder

By hardcoding all values in the notebook

A pipeline needs to process files that arrive in a folder with a timestamp in the name, such as `data_20240115_060000.csv`. The pipeline should process the most recent file. The team wants to avoid hardcoding the file name. What is the best approach?

Use a Get Metadata activity to list files and a Filter activity to select the most recent, then pass the file name to the Copy activity

Use a Dataflow Gen 2 to read all files and pick the latest

Use a notebook that lists files and picks the latest, then calls the Copy activity

Hardcode the file name in the Copy activity and update it manually

A company has a pipeline that must run at 5:00 AM every day. However, the upstream data source is often late, and the pipeline fails if data is not available. The team wants to avoid manual intervention and ensure the pipeline eventually runs successfully. What should they do?

Schedule the pipeline at 5:00 AM and set a wait activity to delay until data is available

Schedule the pipeline at 5:00 AM and add a retry policy with a long timeout

Schedule the pipeline at 5:00 AM and use a conditional activity to check for data, looping until it appears

Use an event-based trigger that fires when the upstream data is ready

A data engineer has a notebook that takes parameters for 'environment' (dev/prod) and 'table_name'. The engineer wants to run the same notebook for multiple tables in a loop within a pipeline. What is the best way to achieve this?

Hardcode the table names in the notebook and run it multiple times manually.

Use a ForEach activity in the pipeline that iterates over a list of table names and calls the notebook activity with parameters.

Create a separate notebook for each table.

Use a Dataflow Gen 2 to loop through tables and call the notebook.

A pipeline must run at 2:00 AM every Monday to process the previous week's data. The pipeline uses a parameter for the start date of the week. What is the best way to set the parameter value?

Use a dynamic expression in the pipeline to calculate the previous Monday's date.

Hardcode the date parameter to a fixed value and update it weekly.

Use a Dataflow Gen 2 to calculate the date and store it in a table.

Use a notebook to calculate the date and pass it to the pipeline.

Microsoft Certified:Fabric Data Engineer Associate

Domain 1Objective 4

Orchestrate Processes DP-700 Practice Questions (Page 4)

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 16–20

16foundation · easy
In a notebook, how can dynamic expressions be used to enhance orchestration?
Select an answer first
17expert · medium
A pipeline needs to process files that arrive in a folder with a timestamp in the name, such as `data_20240115_060000.csv`. The pipeline should process the most recent file. The team wants to avoid hardcoding the file name. What is the best approach?
Select an answer first
18expert · medium
A company has a pipeline that must run at 5:00 AM every day. However, the upstream data source is often late, and the pipeline fails if data is not available. The team wants to avoid manual intervention and ensure the pipeline eventually runs successfully. What should they do?
Select an answer first
19application · medium
A data engineer has a notebook that takes parameters for 'environment' (dev/prod) and 'table_name'. The engineer wants to run the same notebook for multiple tables in a loop within a pipeline. What is the best way to achieve this?
Select an answer first
20application · medium
A pipeline must run at 2:00 AM every Monday to process the previous week's data. The pipeline uses a parameter for the start date of the week. What is the best way to set the parameter value?
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.