Administering a SQL Database Infrastructure — Question 120

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?

Answer options

• A. a schedule
• B. an alert
• C. an operator
• D. a proxy

Correct answer: D

Explanation

Using a proxy allows you to run a SQL Server Agent job step with elevated permissions under a different user account. Options A, B, and C do not provide the capability to change the security context for the job step, making them unsuitable for this requirement.