Microsoft
DP-300 · Question #30
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 exh
Sign in or unlock DP-300 to reveal the answer and full explanation for question #30. The question stem and answer options stay visible for context.
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
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.