You work as DBA at AIOTestKing.com. You administer a Microsoft Windows Server 2003 computer. Your company purchases a new enterprise sales application that runs SQL Server 2005. 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 to run under the appropriate context for the installation of the new enterprise sales application. Under which context should the SQL Server service run?
A.
under the context of the domain user account
B.
under the context of the local service account
C.
under the context of the local Administrator account
D.
under the context of the local system account
Explanation:
When using the EXECUTE AS clause and providing a username and password, it is easiest to use a domain user account with the minimum amount of privileges needed to execute the task it should do.