What steps should you take?

You work as the network administrator at ABC.com. ABC.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 ABC.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 steps should you take?

You work as the network administrator at ABC.com. ABC.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 ABC.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 steps should you take?

A.
You should consider running the SQL Server service under the global system account.

B.
You should consider running the SQL Server service under the local service account.

C.
You should consider running the SQL Server service under the domain local account.

D.
You should consider running the SQL Server service under the domain user account.

E.
You should consider running the SQL Server service under the local Administrator account.

F.
You should consider running the SQL Server service under the mixed user account.

G.
You should consider running the SQL Server service under the local system account.

H.
You should consider running the SQL Server service under the global Administrator account.

I.
You should consider running the SQL Server service under the global service account.

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *