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.
Bạn đang xem 19. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P146 PPS