DP-300 Certification Practice Question #263

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?

Accepted Answer

In Azure SQL Database, when a user attempts to view the Database Properties (specifically the Options and Database Scoped Configurations pages) in Microsoft SQL Server Management Studio (SSMS), SSMS queries various dynamic management views (DMVs) to retrieve the configuration values. Querying these DMVs requires the database-level permission **VIEW DATABASE STATE** (or VIEW DATABASE PERFORMANCE STATE). Without this permission, SSMS will raise an error and fail to display the properties dialog.

More DP-300 practice questions