You work as the network administrator at Domain.com. Domain.com has acquired an enterprise application that runs SQL Server 2008.
The stored procedures that the application uses make use of the EXECUTE AS clause that makes use of the Microsoft Windows accounts.
A new Domain.com security policy requires that all enterprise applications must run under the
context of a service account. It is imperative that this account complies with the company policy
that states all accounts must have the least amount of privileges whilst allowing duties to be
carried out. Consequently this service account must have as little privileges as possible. You have
received instructions to configure the SQL Server service to be used in a suitable context for the
installation of the new enterprise application.
What should you do?
A.
You should consider running the SQL Server service under the domain user account.
B.
You should consider running the SQL Server service under the local system account.
C.
You should consider running the SQL Server service under the local Administrator account.
D.
You should consider running the SQL Server service under the local service account.