Microsoft
70-432 · Question #28
You are the administrator of a SQL Server 2008 instance. You upgraded this instance to SQL Server 2008. You configure the Agent service to use the LocalSystem account. There is a file named…
The correct answer is C. You should configure the job step to use a proxy account. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance. You upgraded this instance to SQL Server 2008. You configure the Agent service to use the LocalSystem account. There is a file named Orderdata on a remote network share. A job accesses this Orderdata file by using a CMDExec step. The job step fails to complete execution after the upgrade. You have to make sure that the job can complete execution, so you have to configure the job step. Which action should you perform?
Options
- AYou should configure a certificate
- BYou should configure the SQL Server Agent service to use the NetworkService account.
- CYou should configure the job step to use a proxy account
- DYou should configure the SQL Server Agent service to use a local Windows account
How the community answered
(25 responses)- A8% (2)
- B4% (1)
- C84% (21)
- D4% (1)
Community Discussion
No community discussion yet for this question.