|
Home > Archive > SQL server exams > January 2003 > Confirm It.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| Please provide the answer and explanation if you have.
You are the SQL administrator for your company. You are planning the security of a new SQL Server 2000 computer in your Windows 2000 domain environment.
You want to accomplish the following goals:
You want the SQL Server services logon account to support communication between the local SQL Server system and remote SQL Server systems using trusted connections.
You want to be able to set up multiserver jobs.
You want the SQL Server services logon account to have the proper password settings to operate efficiently.
You want the SQL Server services logon account to have the proper permissions to operate at all times.
You take the following actions:
You configure a domain user account with membership in the local Administrators Windows 2000 group, apply the Password Never Expires attribute, and specify all logon hours. You specify this domain user account to run both the SQL Server service and the SQL Server Agent service.
Which goal or goals are met by these actions? (Choose all that apply.)
A. The SQL Server services logon account supports communication between the local SQL Server system and remote SQL Server systems using trusted connections.
B. You can set up multiserver jobs.
C. The SQL Server services logon account has the proper password settings to operate efficiently.
D. The SQL Server services logon account has the proper permissions to operate at all times. | |
| naresh_sky 2003-01-07, 5:06 am |
| hi hayat.
well i think all of your
points will work with the settings u mentioned as far as i know.
1) reason:
sql server services need the kerberose
protocal for trusted connection in a network which ur window 2000 has by default.
2)in multi server jobs the agent services
need the global account of the admin
group which u have
3)ur admin password to run the sql services
makes it possible
4)as u said it to never expire and al time
login it makes sence.
well this is my point any one can correct this
cheers
naresh | |
| gcoliveira 2003-01-07, 8:24 am |
| Hayat,
I think Naresh is right...
I'd choose as the answer, BCD.
[]s Giuliano | |
| mickthepom 2003-01-08, 5:31 pm |
| Questions like this just don't provide enough information to give an answer but my guess is A, C, D because to setup multiserver jobs (B) would probably (depending on job dependencies) also require the installation of Distributed Transaction Coordinator and the addition of the domain login account to the local admin group on each server involved in the jobs. |
|
|
|
|