2. Last month your company went through an exercise to standardize service
accounts while you were on holiday. You’ve just restarted SQL Server after
applying a service pack, and now the instance won’t start. You check the
Windows Event Log and see lots of errors about not being able to open the
error log. What is the most likely cause?
A. The SQL Server Service account was not changed using SQL Server
Configuration Manager
B. The service pack failed
C. Data corruption
D. You don’t have the right permissions to the error log
Correct Answer & Explanation: A. If you don’t use the Configuration
Manager tool to change the service account, it will not get explicit permis-
sions to the SQL Server directory structure. SQL Server will not start without
permissions to create an error log file.
Incorrect Answers & Explanations: B, C, D. Answer B is incorrect, although
technically feasible; the service pack should have generated errors if there was a
problem, and given the scenario it is not the most likely cause. Answer C is
incorrect, although technically feasible; given the lack of any other errors and
the scenario it is not the most likely cause. Answer D is incorrect because the
issue is with the Service Account permissions, not your account. To install the
service pack you would have needed full Administrator rights on the server
anyway.
Bạn đang xem 2. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P143 PPTX