You administer a Microsoft SQL Server 2012 database.
You have a SQL Server Agent job instance that runs using the service account. You have a job step within the
job that requires elevated privileges.
You need to ensure that the job step can run using a different user account.
What should you use?
A.
a schedule
B.
an alert
C.
an operator
D.
a proxy
Explanation:
A SQL Server Agent proxy defines the security context for a job step. A proxy provides SQL Server Agent with
access to the security credentials for a Microsoft Windows user. Each proxy can be associated with one or
more subsystems. A job step that uses the proxy can access the specified subsystems by using the security
context of the Windows user. Before SQL Server Agent runs a job step that uses a proxy, SQL Server Agent
impersonates the credentials defined in the proxy, and then runs the job step by using that security context.
https://technet.microsoft.com/en-us/library/ms189064(v=sql.105).aspx