Exam DP-300 topic 7 question 1 discussion

Actual exam question from Microsoft's DP-300

Question #: 1
Topic #: 7

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?

A. GRANT SHOWPLAN TO DevUser
B. GRANT VIEW DEFINITION TO DevUser
C. GRANT VIEW DATABASE STATE TO DevUser
D. GRANT SELECT TO DevUser

Show Suggested Answer

Suggested Answer: C 🗳️

by Luke97 at Dec. 11, 2020, 11:43 a.m.

Comments

Submit Cancel

Luke97

Highly Voted 4 years ago

GRANT VIEW DATABASE STATE TO [<user>];

upvoted 14 times

...

Corbiz

Highly Voted 3 years, 9 months ago

All wrong. Tested myself on SQL 2019. No privilege is needed to view the Options properties. Only adding user to the database was enough (CREATE USER [DevUser] FOR LOGIN [DevUser])

upvoted 5 times

Raffer

3 years, 8 months ago

I just tested it, and VIEW DATABASE STATE is required. "VIEW DATABASE STATE permission denied in database 'myDatabase'. The user does not have permission to perform this action. (Microsoft SQL Server, Error: 262)"

upvoted 5 times

...

learnazureportal

Most Recent 6 months ago

Selected Answer: B

The correct is B. GRANT VIEW DEFINITION TO DevUser

upvoted 2 times

...

voodoo_sh

10 months, 3 weeks ago

Tested on SQL Server 2017 - no privilege was needed to view the Options properties. Only adding user to the database was enough. Tested on Azure SQL Database - it says "VIEW DATABASE PERFORMANCE STATE" was required. Granted VIEW DATABASE STATE - it worked, could open Properties after that.

upvoted 1 times

...

eric0718

2 years, 7 months ago

Selected Answer: C

Answer is correct

upvoted 3 times

...

Jas_dandiwal

3 years, 9 months ago

answer is correct you need view database state permission

upvoted 2 times

...