DP-700 Monitor and Optimize an Analytics Solution Practice Question
When monitoring Fabric Data Pipelines, which TWO metrics are most useful for identifying performance issues in data copy activities?
⚠ Common exam trap
Candidates often focus on CPU or memory usage metrics, which are less relevant for copy activities than throughput and duration, the primary indicators of data movement performance.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Data throughput (MB/s).
In a copy activity, identifying data throughput and the duration of the 'Data Integration Unit' (DIU) utilization is critical. If the throughput is low, it suggests network constraints or inefficient serialization/deserialization. Monitoring the duration allows engineers to understand if the activity is hitting concurrency limits or if source/destination systems are struggling to keep up with the data volume requested by the copy operation.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Data throughput (MB/s).
Why this is correct
Throughput is the primary indicator of how efficiently data is being transferred between the source and destination. Low throughput often points to bottlenecks such as network bandwidth, source system limitations, or inefficient data format conversion during the copy process.
- ✗
Number of active users in the workspace.
Why it's wrong here
While user activity can impact capacity, it is not a direct metric for the performance of an individual pipeline copy activity. Pipeline performance is governed by resource allocation and system efficiency, regardless of how many users are logged into the workspace at that moment.
- ✓
Activity duration.
Why this is correct
Monitoring the total duration of the copy activity helps establish a performance baseline. Significant deviations from this baseline indicate potential issues in the pipeline execution environment, such as transient network slowdowns or resource contention within the Fabric capacity assigned to the data integration task.
- ✗
Total number of rows in the destination table.
Why it's wrong here
The final row count only confirms that the data has landed. It does not provide any telemetry on the performance or efficiency of the transfer process itself, which is needed to identify bottlenecks or troubleshoot why a pipeline took longer than expected.
- ✗
The name of the user who triggered the pipeline.
Why it's wrong here
The user identity is relevant for security and auditing but provides no diagnostic value when investigating performance bottlenecks in a copy activity. Performance issues are technical in nature and depend on infrastructure and data constraints, not on the identity of the person who initiated the run.
About these practice questions
Courseiva writes every DP-700 question from scratch — 152 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Microsoft exam blueprint
This DP-700 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-700 exam.