Administering Microsoft SQL Server 2012/2014 Databases — Question 63

Which of the following permissions must a user have in order to query all of the built-in Dynamic Management views?

Answer options

• A. VIEW ALL
• B. SELECT ALL VEWS
• C. VIEW SERVER INFO
• D. VIEW SERVER STATE

Correct answer: D

Explanation

The correct answer is D, VIEW SERVER STATE, which allows users to access Dynamic Management views. The other options either do not provide the necessary access or are incorrect permissions related to viewing server information.