MicrosoftMicrosoft
DP-203 · Question #405
DP-203 Question #405: Real Exam Question with Answer & Explanation
The correct answer is A: VIEW DATABASE STATE. https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data- warehouse-manage-monitor
Submitted by jordan8· Mar 30, 2026
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
Explanation
https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data- warehouse-manage-monitor
Community Discussion
No community discussion yet for this question.