Secure, monitor, and optimize data storage and data processing →mediumMultiple ChoiceObjective-mapped
DP-203 Practice Question: Secure, monitor, and optimize data storage and data processing
Your organization uses Azure Synapse Analytics serverless SQL pool to query data in Azure Data Lake Storage Gen2. You notice that queries are taking longer than expected. You need to identify which queries are consuming the most resources and optimize them. What should you do first?
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
✓
Query the sys.dm_exec_requests DMV to view running queries and their resource usage.
Querying the sys.dm_exec_requests DMV provides real-time resource consumption data for running queries in serverless SQL pool, allowing identification of the most resource-intensive queries. Option A is incorrect because query hints optimize execution but should be applied after identifying problematic queries. Option C is incorrect as diagnostic settings send logs to Log Analytics, but DMVs offer immediate insights without additional configuration. Option D is incorrect because serverless SQL pool automatically manages statistics, and creating additional statistics is not the priority when first troubleshooting resource consumption.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use query hints to optimize execution plans.
Why it's wrong here
Hints require knowing which queries to optimize.
- ✓
Query the sys.dm_exec_requests DMV to view running queries and their resource usage.
Why this is correct
DMVs give real-time insight into resource consumption.
- ✗
Enable diagnostic settings and send query logs to Log Analytics.
Why it's wrong here
Logs are for historical analysis, not immediate.
- ✗
Create statistics on all columns used in queries.
Why it's wrong here
Serverless SQL pool auto-creates statistics.
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
Courseiva writes every DP-203 question from scratch — 760 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 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.