Question

Which of the following server-scoped permissions grants permission to execute DBCC commands that affect the contents of the buffer pool?

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

Answer 1

The correct answer is D. VIEW SERVER STATE which grants permission to execute DBCC commands that affect the contents of the buffer pool.

Step-by-step explanation:

The correct answer is D. VIEW SERVER STATE which grants permission to execute DBCC commands that affect the contents of the buffer pool. VIEW SERVER STATE permission allows a user to see the operating system information and performance statistics, as well as execute the DBCC commands.

For example, a DBA might use DBCC commands to monitor and troubleshoot SQL Server instances. These commands can be used to check the integrity of a database, track performance issues, or find and fix any errors in the buffer pool.

Having the VIEW SERVER STATE permission is essential for administrators and developers who need to access and manage the internal details and performance of a SQL Server instance.