nerdexam
Microsoft

70-458 · Question #140

70-458 Question #140: Real Exam Question with Answer & Explanation

Sign in or unlock 70-458 to reveal the answer and full explanation for question #140. The question stem and answer options stay visible for context.

Question

You administer two Microsoft SQL Server 2012 servers named ProdSrv1 and ProdSrv2. ProdSrv1 is configured as a Distributor. Both servers are configured to use the windows NT Service virtual accounts for all SQL Services. You are configuring snapshot replication from ProdSrv1 to ProdSrv2 by using ProdSrv2 as a pull subscriber. The distribution agent on ProdSrv2 regularly fails, displaying the following error message: "Cannot access the file. Operating system error code 5 (Access is denied.)." You need to configure the distribution agent by granting only the minimum required access to all accounts. What should you do?

Options

  • AConfigure the SQL Server Agent service to run under the Local System account.
  • BConfigure the SQL Server Agent service to run under a Windows domain account.
  • CConfigure the Subscriber to use the Local System account.
  • DConfigure the Subscriber to use a Windows domain account.

Unlock 70-458 to see the answer

You've previewed enough free 70-458 questions. Unlock 70-458 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 70-458 Practice