Microsoft Fabric Data Engineer Associate DP-700 Practice Question
You must automate ingestion and cleansing of JSON files from an Azure Storage container into a Lakehouse table in Microsoft Fabric. The process will run hourly, execute PySpark code for data quality checks, and post a Microsoft Teams alert only if the PySpark step fails. Business analysts with limited coding skills need to adjust the trigger schedule without editing code. Which Fabric item should you build to implement the orchestration logic?
Schedule a single Spark notebook that performs the copy, transformation, and Teams notification entirely in code.
Build the solution as a Dataflow Gen2 with incremental refresh and an hourly refresh schedule.
Create a pipeline in the workspace and add Copy, Notebook, and Teams activities with an hourly trigger.
Configure a Spark job definition and rely on the job scheduler to run the notebook and send alerts.
A Fabric pipeline provides a graphical, low-code canvas where you can chain activities such as Copy data, Notebook, and Webhook/Teams notification, configure error paths, and manage schedules or event triggers. Analysts can modify the hourly trigger directly in the pipeline UI without touching the PySpark code. A Spark notebook on its own focuses on code execution and would require custom logic for copy, error handling, and notifications. Dataflow Gen2 is aimed at data preparation inside Power Query and cannot call a PySpark notebook or send Teams messages on failure. A standalone Spark job definition similarly lacks built-in branching, external activity support, and a visual trigger editor.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is a Fabric pipeline, and how does it differ from other Fabric items?
Open an interactive chat with Bash
How does the hourly trigger work in a Fabric pipeline, and why is it important?
Open an interactive chat with Bash
Why can’t Dataflow Gen2 or Spark job definitions handle this orchestration task?
Open an interactive chat with Bash
Microsoft Fabric Data Engineer Associate DP-700
Implement and manage an analytics solution
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .