Question

Which of the following server-scoped permissions grants SELECT permissions on server-level dynamic management objects?

A. ALTER TRACE
B. ALTER ANY LOGIN
C. VIEW SERVER STATE
D. ALTER SERVER STATE

Answer 1

The correct answer is C. VIEW SERVER STATE

Step-by-step explanation:

The correct answer is C. VIEW SERVER STATE. This server-scoped permission grants SELECT permissions on server-level dynamic management objects. Dynamic management objects are used by administrators to monitor the server and gather information about its current state.