Microsoft Fabric Data Engineer Associate DP-700 Practice Question
You must transform 200 GB of semi-structured logs in OneLake. Engineers need to use Python libraries like pandas and scikit-learn for feature engineering and visual analysis, then write the result to a Delta Lake table. The code should support iterative development and be runnable on a scheduled Fabric pipeline. Which Fabric transformation option best meets the requirements?
Spark notebooks in Microsoft Fabric run on Apache Spark, allowing PySpark and native Python packages such as pandas and scikit-learn for complex data preparation and machine-learning tasks. Notebooks provide an interactive environment for iterative development and visualization, can write directly to Delta Lake tables, and are first-class activities that can be scheduled within Fabric Data Factory pipelines. Dataflow Gen2 offers a low-code Power Query experience but cannot execute arbitrary Python or advanced ML libraries. KQL update policies are suited to streaming ingestion and Kusto databases, not large batch processing with external Python packages. T-SQL stored procedures in a warehouse are limited to SQL operations and do not support Python libraries or Spark-based scalability.
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 Apache Spark and how does it work in Microsoft Fabric?
Open an interactive chat with Bash
What is Delta Lake, and why is it suitable for storing transformed data?
Open an interactive chat with Bash
How do Fabric pipelines support Spark notebooks for scheduled execution?
Open an interactive chat with Bash
Microsoft Fabric Data Engineer Associate DP-700
Ingest and transform data
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 .