A data engineer has a notebook that processes data for a specific date. The notebook is called from a pipeline that runs daily. The engineer wants to be able to manually run the notebook with a specific date for testing. What is the best way to design the notebook?

Hardcode the date in the notebook and change it for testing

Use a notebook parameter with a default value of the current date

Create two versions of the notebook, one for pipeline runs and one for testing

Use a pipeline variable to set the date and pass it to the notebook

A pipeline needs to copy files from a folder that changes daily, such as `data/2024/01/15/`. The pipeline should use the current date to construct the folder path. What is the best way to implement this?

Use a Dataflow Gen 2 to generate the folder path

Create a new pipeline for each day

Use a dynamic expression in the source dataset that references the current date

Hardcode the folder path and update it manually each day

A pipeline has multiple activities that depend on each other. The team wants to implement error handling so that if any activity fails, a notification is sent and the pipeline stops. What is the best way to achieve this?

Use a Dataflow Gen 2 to handle error notifications.

Use a single 'On failure' condition on the last activity only.

Use a notebook to wrap all activities and handle errors.

Add an 'On failure' completion condition to each activity that points to a web activity that sends a notification, and set the pipeline to stop on failure.

A team has a pipeline that processes files uploaded to a specific Azure Data Lake Storage Gen2 container. They want the pipeline to start automatically as soon as a new file arrives, without any manual intervention. What should you configure?

Use a Dataflow Gen 2 with a scheduled refresh to pick up new files.

Add a scheduled trigger that runs every 5 minutes and checks for new files.

Configure a notebook to run continuously and watch for new files.

Create an event-based trigger that fires on blob creation in the container.

Which scenario is best suited for an event-based trigger?

Running a pipeline after a manual approval

Running a pipeline every hour to check for new data

Running a monthly report on the first day of each month

Processing a file as soon as it is uploaded to a data lake

Microsoft Certified:Fabric Data Engineer Associate

Domain 1Objective 4

Orchestrate Processes DP-700 Practice Questions (Page 1)

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 1–5

1expert · medium
A data engineer has a notebook that processes data for a specific date. The notebook is called from a pipeline that runs daily. The engineer wants to be able to manually run the notebook with a specific date for testing. What is the best way to design the notebook?
Select an answer first
2application · medium
A pipeline needs to copy files from a folder that changes daily, such as `data/2024/01/15/`. The pipeline should use the current date to construct the folder path. What is the best way to implement this?
Select an answer first
3expert · hard
A pipeline has multiple activities that depend on each other. The team wants to implement error handling so that if any activity fails, a notification is sent and the pipeline stops. What is the best way to achieve this?
Select an answer first
4application · medium
A team has a pipeline that processes files uploaded to a specific Azure Data Lake Storage Gen2 container. They want the pipeline to start automatically as soon as a new file arrives, without any manual intervention. What should you configure?
Select an answer first
5foundation · easy
Which scenario is best suited for an event-based trigger?
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.