Microsoft Fabric Data Engineer Associate DP-700 Practice Question
You manage a Microsoft Fabric Data Factory pipeline that runs hourly and executes a single Copy data activity to move 500 GB of CSV files from an on-premises SFTP server to a OneLake lakehouse. The self-hosted integration runtime has eight CPU cores and currently finishes in 45 minutes, violating the 30-minute SLA. Without adding more compute resources or additional activities, which Copy data setting change is most likely to reduce the run time?
Enable verbose run-time logging for the activity.
Turn off staging by setting the EnableStaging option to false.
Increase the degree of copy parallelism to 8.
Reduce the data integration units (DIUs) for the activity from 4 to 2.
Copy data throughput on a self-hosted integration runtime is frequently limited by the number of parallel reader and writer threads the activity can open. Increasing the degree of copy parallelism from its default value (up to a maximum of eight threads for an eight-core runtime) allows the activity to transfer multiple files concurrently, better utilizing available CPU and network bandwidth. Disabling staging, lowering DIUs, or enabling verbose logging do not increase concurrency and therefore provide little or no performance improvement in this scenario.
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 copy parallelism in a Microsoft Fabric Data Factory pipeline?
Open an interactive chat with Bash
How does the self-hosted integration runtime impact pipeline performance?
Open an interactive chat with Bash
Why wouldn’t disabling staging improve the pipeline performance?
Open an interactive chat with Bash
Microsoft Fabric Data Engineer Associate DP-700
Monitor and optimize 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 .