Crucial Exams

Microsoft Fabric Data Engineer Associate DP-700 Practice Question

You manage a Microsoft Fabric pipeline that runs every hour to copy transaction logs from an Azure Storage account into a lakehouse and then executes a notebook to aggregate the data. Recently the overall pipeline duration increased from 15 minutes to over 40 minutes even though the data volume has grown by only 10 percent. You verify that

  • The Storage account and Fabric workspace are in the same Azure region.
  • The notebook still finishes in less than 5 minutes. You determine that the Copy activity is the bottleneck. You need to reduce the time the Copy activity spends transferring data without changing the source or destination. Which change will most likely improve the Copy activity performance?

  • Consolidate the source files into larger single files before the Copy activity runs.

  • Lower the fault-tolerance retry count from 3 to 1.

  • Increase the Data Integration Units (DIUs) allocated to the Copy activity.

  • Enable staging by loading the data into a temporary Azure SQL Database first.

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