You have an Azure SQL database named DB3. You need to provide a user named DevUser with the ability to view the properties of DB3 from Microsoft SQL Server Management Studio (SSMS) as shown in the…

The correct answer is C. GRANT VIEW DATABASE STATE TO DevUser. The exhibits displays Database [State] properties. To query a dynamic management view or function requires SELECT permission on object and VIEW SERVER STATE or VIEW DATABASE STATE permission…

Submitted by dimitri_ru· Mar 6, 2026Perform administration by using T-SQL

Question

You have an Azure SQL database named DB3. You need to provide a user named DevUser with the ability to view the properties of DB3 from Microsoft SQL Server Management Studio (SSMS) as shown in the exhibit. (Click the Exhibit tab.) Which Transact-SQL command should you run?

Exhibits

Options

AGRANT SHOWPLAN TO DevUser
BGRANT VIEW DEFINITION TO DevUser
CGRANT VIEW DATABASE STATE TO DevUser
DGRANT SELECT TO DevUser

How the community answered

(38 responses)

A
5% (2)
B
3% (1)
C
82% (31)
D
11% (4)

Explanation

The exhibits displays Database [State] properties. To query a dynamic management view or function requires SELECT permission on object and VIEW SERVER STATE or VIEW DATABASE STATE permission. https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-properties-options-

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice