What should you use?

You administer a Microsoft SQL Server 2016 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

View Answer

Answer: D