70-450 · Question #46
You are the administrator of a Microsoft Windows Server 2003 computer. Your company purchases a new enterprise sales application that runs SQL Server 2008. The application uses stored procedures…
The correct answer is C. Under the context of the domain user account. See the full explanation below for the reasoning.
Question
You are the administrator of a Microsoft Windows Server 2003 computer. Your company purchases a new enterprise sales application that runs SQL Server 2008. The application uses stored procedures that include the EXECUTE AS clause and that use Microsoft Windows accounts. The company's written security policy states that all enterprise applications must run under the context of a service account that requires the minimum amount of privileges. You need to configure the SQL Server service torun under the appropriate context for the installation of the new enterprise sales application. Under which context should the SQL Server service run?
Options
- AUnder the context of the local system account
- BUnder the context of the local service account
- CUnder the context of the domain user account
- DUnder the context of the local Administrator account
How the community answered
(23 responses)- A13% (3)
- B4% (1)
- C78% (18)
- D4% (1)
Community Discussion
No community discussion yet for this question.