Which of the following actions should you take?

You work as a database administrator at ABC.com.ABC.com is making use SQL Server 2008 R2
in their environment.
ABC.com has a server, named ABC-SR07, which runs an instance of SQL Server 2008 R2 and
has multiple applications installed.
You have configured the SQL Server Agent service to make use of the ABC-SR07/ACCOUNT.
You then configured a job that must be written to a database server. You now need to make sure
that only the SQL Server Agent service has read and write permissions to the database server.
Which of the following actions should you take?

You work as a database administrator at ABC.com.ABC.com is making use SQL Server 2008 R2
in their environment.
ABC.com has a server, named ABC-SR07, which runs an instance of SQL Server 2008 R2 and
has multiple applications installed.
You have configured the SQL Server Agent service to make use of the ABC-SR07/ACCOUNT.
You then configured a job that must be written to a database server. You now need to make sure
that only the SQL Server Agent service has read and write permissions to the database server.
Which of the following actions should you take?

A.
You should consider configuring the SQL Server Agent service to make use of a global
Administrator account.

B.
You should consider configuring the SQL Server Agent service to make use of a proxy account.

C.
You should consider configuring the SQL Server Agent service to make use of a Local Service
account.

D.
You should consider configuring the SQL Server Agent service to make use of a remote
System account.

Explanation:



Leave a Reply 0

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