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…
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, 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
How the community answered
(22 responses)- A77% (17)
- B14% (3)
- C5% (1)
- D5% (1)
Explanation
https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data- warehouse-manage-monitor
Topics
#DMV permissions#VIEW DATABASE STATE#dedicated SQL pool#least privilege
Community Discussion
No community discussion yet for this question.