Microsoft Exam DP-300 Topic 11 Question 8 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 8
Topic #: 11

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?

AGRANT SHOWPLAN TO DevUser

BGRANT VIEW DEFINITION TO DevUser

CGRANT VIEW DATABASE STATE TO DevUser

DGRANT SELECT TO DevUser

Show Suggested Answer

Suggested Answer: C

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-page

by Marjory at May 03, 2022, 07:02 PM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!