nerdexam
Microsoft

DP-300 · Question #206

You provision an Azure SQL Managed Instance database named MyDevData. The database will be used by in-house development for application development projects. DevSupport custom database role members…

The correct answer is A. GRANT VIEW DATABASE STATE TO DevSupport. To allow DevSupport members to view dynamic management views (DMVs) for the MyDevData database, the GRANT VIEW DATABASE STATE permission should be assigned.

Submitted by manish99· Mar 6, 2026Implement a secure environment

Question

You provision an Azure SQL Managed Instance database named MyDevData. The database will be used by in-house development for application development projects. DevSupport custom database role members will use dynamic management views (DMVs) to retrieve performance and health information about MyDevData. You need to ensure that DevSupport members can view information through DMVs. Which statement should you use? Each correct answer presents part of the solution.

Options

  • AGRANT VIEW DATABASE STATE TO DevSupport
  • BGRANT VIEW SERVER STATE TO DevSupport
  • CGRANT VIEW DEFINITION TO DevSupport
  • DGRANT VIEW REFERENCES TO DevSupport

How the community answered

(44 responses)
  • A
    77% (34)
  • B
    14% (6)
  • C
    5% (2)
  • D
    5% (2)

Why each option

To allow DevSupport members to view dynamic management views (DMVs) for the MyDevData database, the GRANT VIEW DATABASE STATE permission should be assigned.

AGRANT VIEW DATABASE STATE TO DevSupportCorrect

The VIEW DATABASE STATE permission grants the ability to see all database-level state information through DMVs and DMOs, which is exactly what is needed for viewing performance and health data specific to the MyDevData database.

BGRANT VIEW SERVER STATE TO DevSupport

VIEW SERVER STATE grants access to server-level DMVs and DMOs, which is broader than the required database-specific scope for MyDevData and not directly applicable to a single database's DMVs.

CGRANT VIEW DEFINITION TO DevSupport

VIEW DEFINITION allows viewing the metadata of securable objects, not dynamic performance or health information from DMVs.

DGRANT VIEW REFERENCES TO DevSupport

VIEW REFERENCES allows viewing object dependency information, which is unrelated to accessing performance and health data through DMVs.

Concept tested: SQL Server database-level permissions for DMVs

Source: https://learn.microsoft.com/en-us/sql/t-sql/statements/grant-database-permissions-transact-sql?view=sql-server-ver16

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-300 Practice