Microsoft
DP-203 · Question #405
You have an Azure Synapse Analytics dedicated SQL pool named SQL1 and a user named User1. You need to ensure that User1 can view requests associated with SQL1 by querying the sys.dm_pdw_exec_requests
Sign in or unlock DP-203 to reveal the answer and full explanation for question #405. The question stem and answer options stay visible for context.
Submitted by jordan8· Mar 30, 2026Secure, monitor, and optimize data storage and data processing
Question
You have an Azure Synapse Analytics dedicated SQL pool named SQL1 and a user named User1. You need to ensure that User1 can view requests associated with SQL1 by querying the sys.dm_pdw_exec_requests dynamic management view. The solution must follow the principle of least privilege. Which permission should you grant to User1?
Options
- AVIEW DATABASE STATE
- BSHOWPLAN
- CCONTROL SERVER
- DVIEW ANY DATABASE
Unlock DP-203 to see the answer
You've previewed enough free DP-203 questions. Unlock DP-203 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#DMV permissions#VIEW DATABASE STATE#dedicated SQL pool#least privilege