DP-700 Monitor and Optimize an Analytics Solution Practice Question
You need to monitor the health and performance of your Microsoft Fabric environment. Which two components should you primarily monitor to identify bottlenecks in data movement?
⚠ Common exam trap
Candidates often select 'Fabric capacity logs' alone. While useful for general health, they lack the specific granularity needed to diagnose connectivity or movement issues inherent to the Gateway and pipeline orchestration.
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
✓
On-premises Data Gateway performance
Bottlenecks in data movement usually occur at the integration boundary, specifically the Gateway or the Pipeline execution engine. Monitoring the Gateway ensures that local data sources can be reached, while monitoring Pipeline activity provides insight into throughput and failure rates. Combined, these two metrics allow engineers to determine if the issue is with network connectivity, local resource constraints, or the orchestration logic itself, which is critical for maintaining reliable end-to-end data pipelines.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
On-premises Data Gateway performance
Why this is correct
The gateway is the conduit for moving data from on-premises sources to Fabric. Monitoring its CPU, memory, and throughput is essential to ensure that data transfer is not being delayed by local network constraints or insufficient gateway capacity, which can often be the hidden cause of pipeline slowdowns.
- ✓
Pipeline activity and duration logs
Why this is correct
Pipeline logs provide visibility into the execution lifecycle of data copy and transformation tasks. By reviewing duration metrics and error logs, you can pinpoint exactly where data movement stalls or fails, allowing for targeted performance tuning or adjustments to the copy activity configuration within the pipeline.
- ✗
OneLake file storage size
Why it's wrong here
While storage size is important for cost tracking, it does not provide any information about the performance or health of data movement. A large amount of data stored in OneLake does not indicate a bottleneck in the transfer of that data, making this metric irrelevant for movement.
- ✗
User interaction counts on Power BI reports
Why it's wrong here
User interaction counts on Power BI reports measure consumption patterns rather than back-end pipeline performance. This metric is useful for report adoption and capacity management, but it offers no insights into the health, speed, or bottlenecks associated with the ingestion and movement of data into the Lakehouse.
- ✗
Workspace user list
Why it's wrong here
The list of users in a workspace is for security and administrative management. It provides no technical information regarding the performance of data integration components, the throughput of copy activities, or the health of underlying data movement infrastructure, making it entirely irrelevant for monitoring performance bottlenecks.
About these practice questions
One of 152 original DP-700 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.