Microsoft Fabric Data Engineer Associate DP-700 Practice Question
You manage a Microsoft Fabric pipeline that processes 300 sub-folders in an Azure Data Lake Storage Gen2 container. A ForEach activity calls a Copy activity for each folder but currently runs sequentially, so the pipeline finishes in over six hours. Without rewriting the Copy activity or adding compute, which change will most reduce the total runtime?
Increase the pipeline run-timeout setting from six hours to eight hours.
Switch the schedule trigger to a tumbling-window trigger with a shorter interval.
Enable staging in each Copy activity and turn on the preserve hierarchy option.
Disable the isSequential setting on the ForEach activity and raise its Batch count to a value such as 50.
A ForEach activity that runs sequentially executes one child activity at a time, eliminating parallelism. Disabling the isSequential property switches the loop to parallel mode, and raising the Batch count (up to the supported maximum of 50) increases the number of concurrent iterations. This parallelism can cut overall duration significantly without modifying the Copy activity or provisioning extra compute. Enabling staging, changing triggers, or extending the timeout does not eliminate the sequential bottleneck.
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 the purpose of disabling the isSequential setting in a ForEach activity?
Open an interactive chat with Bash
What is the Batch count in a ForEach activity, and how does it affect performance?
Open an interactive chat with Bash
Why don’t staging or triggers eliminate the sequential bottleneck in this scenario?
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 .