DP-203 Practice Question: Secure, monitor, and optimize data storage and data processing
You have an Azure Synapse Analytics serverless SQL pool. You need to monitor the number of queries that are currently executing. Which dynamic management view should you query?
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
✓
sys.dm_exec_requests
Sys.dm_exec_returns detailed information about each request currently executing on the serverless SQL pool, including its state, command, and session ID. This DMV is specifically designed for monitoring active queries. Option A (sys.dm_resource_governor_workload_groups) shows workload group configuration and resource statistics, not current requests. Option B (sys.dm_exec_query_stats) provides cumulative performance statistics for cached query plans, not currently executing queries. Option D (sys.dm_exec_sessions) contains session-level information but does not indicate which sessions are actively executing a request.
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_resource_governor_workload_groups
Why it's wrong here
sys.dm_resource_governor_workload_groups shows workload group configuration and resource statistics, not current requests.
- ✗
sys.dm_exec_query_stats
Why it's wrong here
sys.dm_exec_query_stats provides cumulative performance statistics for cached query plans, not currently executing queries.
- ✓
sys.dm_exec_requests
Why this is correct
sys.dm_exec_requests shows currently executing requests in the serverless SQL pool, including state, command, and session ID.
- ✗
sys.dm_exec_sessions
Why it's wrong here
sys.dm_exec_sessions contains session-level information but does not indicate which sessions are actively executing a request.
Quick reference
Cloud Service Model Comparison
| Model | You Manage | Provider Manages | Examples |
|---|---|---|---|
| IaaS | OS, runtime, apps, data | Hardware, hypervisor, networking | EC2, Azure VMs, GCP Compute Engine |
| PaaS | Apps and data | OS, runtime, middleware, hardware | Elastic Beanstalk, Azure App Service |
| SaaS | Data and settings only | Everything else | Microsoft 365, Salesforce, Workday |
| FaaS / Serverless | Function code only | Infra, scaling, runtime | Lambda, Azure Functions, Cloud Run |
| CaaS | Containers and apps | Kubernetes, OS, hardware | EKS, AKS, GKE |
Go deeper
Related to this question
About these practice questions
One of 760 original DP-203 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 by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-203 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-203 exam.