DP-300 · Question #30
DP-300 Question #30: Real Exam Question with Answer & Explanation
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. https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-properties-
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?
Options
- AGRANT SHOWPLAN TO DevUser
- BGRANT VIEW DEFINITION TO DevUser
- CGRANT VIEW DATABASE STATE TO DevUser
- DGRANT SELECT TO DevUser
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.