YOU HAVE A SQL SERVER AGENT JOB CONFIGURED TO RUN T/SQL STATEMENTS...

11. You have a SQL Server Agent job configured to run T/SQL statements. The job runs under a domain account that is not a member of the sysadmin fixed server role. You wish to add a Command Exec job step to the job. The job fails on the step because the domain account doesn’t have rights to run Command Exec job steps. What should you do to correct this issue without granting excessive rights to the instance?A. Make the logon a member of the sysadmin fixed server role.B. Make the logon a member of the Windows Administrators group on the server.C. Create a credential based on the Windows logon. Create a proxy based on the credential. Grant the logon rights to the proxy. Assign the proxy to run the job step.D. Create a proxy based on the Windows logon. Create a credential based on the proxy. Grant the logon rights to the credential. Assign the credential to run the job step.