WHAT IS USED TO APPLY APPROPRIATE SUBSYSTEM PERMISSIONS TO SQL SER...

19. What is used to apply appropriate subsystem permissions to SQL Server Agent

tasks?

A. Database-level roles

B. Proxies

C. Server-level roles

D. Credentials

The correct answer is B. Proxies can be set up to use with SQL Server to

establish the appropriate permissions for the various tasks performed by SQL

Server Agent job steps. Answers A and C are incorrect since permissions for

SQL Server Agent tasks are not defined through either database-level or

server-level roles. Answer D is incorrect since proxies are used by the SQL

Server Agent. Credentials are necessary to establish the proxy but are not

used directly.