DP-700 Monitor and Optimize an Analytics Solution Practice Question
You need to monitor the historical performance of queries in a Fabric Warehouse to identify which ones frequently use the most CPU time. Which Dynamic Management View (DMV) should you query?
⚠ Common exam trap
Candidates often guess 'sys.dm_exec_requests'. This view only shows currently active or queued queries and does not provide a historical log of past execution performance or resource consumption patterns.
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
✓
queryinsights.exec_requests_history
Fabric Warehouse provides several DMVs to monitor query execution. The 'sys.dm_exec_requests' view shows currently running queries, but for historical analysis, 'queryinsights.exec_requests_history' (or similar views in the queryinsights schema) provides the necessary data on completed queries, including their duration and resource consumption over time.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
sys.dm_pdw_nodes_os_performance_counters
Why it's wrong here
This DMV provides low-level performance counters for the underlying nodes, such as CPU percentage and disk IO. While useful for infrastructure health, it does not link performance data back to individual SQL queries, making it difficult to use for identifying specific problematic queries in the warehouse.
- ✓
queryinsights.exec_requests_history
Why this is correct
This view is specifically designed for Fabric Warehouse monitoring. It records details of every query that has finished executing, including the total CPU time, duration, and the amount of data processed. This allows data engineers to build reports on query performance trends and identify candidates for optimization.
- ✗
sys.dm_tran_active_transactions
Why it's wrong here
This DMV is used to monitor currently active transactions and their state. While it can help identify long-running transactions that might be blocking others, it does not provide historical CPU usage or a record of completed queries, which is what is required for performance trend analysis.
- ✗
sys.dm_exec_sessions
Why it's wrong here
The 'sys.dm_exec_sessions' view shows information about all active connections to the warehouse. It includes details like login name and session start time, but it does not provide the query-level execution metrics or the historical data needed to analyze CPU consumption over a period of time.
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.