• Description:Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
• Passing Score:75%
• Practice Test - Number of questions:103 questions
• Simulation Test - Number of questions:103 questions
• Simulation Test Duration:41 minutes
• Has explanations:No

You need to ensure that customers will be able to administer their databases and other SQL Server settings. What should you do for each customer?

Answer(s)

1. Place the appropriate database user accounts into the customer db_datareader and db_datawriter fixed database roles.
2. For each customer, place the appropriate logins into the sysadmin fixed server role.
3. For each customer, create a local Windows user account on the appropriate SQL Server computer and place the account into the local Administrators group.
4. For each customer, create a local Windows user account on the appropriate SQL Server computer and place the account into the local Server Operators group.

For each customer, place the appropriate logins into the sysadmin fixed server role.