Crucial Exams

Microsoft Fabric Data Engineer Associate DP-700 Practice Question

Your nightly Fabric pipeline copies about 200 CSV files (2 GB each) from Azure Data Lake Storage Gen2 into a lakehouse. It first runs Get Metadata, then a sequential ForEach loop that executes one Copy Data activity per file. The run now lasts more than six hours, exceeding the maintenance window. You need to cut the duration by at least 50 percent with minimal redesign. What should you do?

  • Keep the loop but set the ForEach activity's batch count to 50 so up to 50 Copy activities run in parallel.

  • Insert an additional Get Metadata activity before the Copy activity to pre-fetch column statistics for each file.

  • Replace the loop with one Copy Data activity that uses a wildcard file path so all CSV files are copied in parallel.

  • Change the pipeline trigger from a single daily schedule to run every 30 minutes.

Microsoft Fabric Data Engineer Associate DP-700
Monitor and optimize an analytics solution
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot