70-667 · Question #53
You have a Microsoft SQL Server 2010 server named Server1. You install SharePoint server 2010 on a server named Server2. Server1 and Server2 are joined to the same Active Directory domain. You…
The correct answer is D. On Server1, assign the dbcreator and the securityadmin server roles to Admin1. BURGOS MNEMO: "dbcreator" 2008-R2-and-SQL-Server-2008-R2-Part-5-Administrative-and-service-accounts.aspx
Question
You have a Microsoft SQL Server 2010 server named Server1. You install SharePoint server 2010 on a server named Server2. Server1 and Server2 are joined to the same Active Directory domain. You create a domain user account named Admin1. On Server2, you add Admin1 to the local Administrators group. You need to ensure that Admin1 can create a server farm with least amount of permissions granted. What should you do?
Options
- AOn a domain controller, add Admin1 to the Domain Admins group.
- BOn Server1, add Admin1 to the local Administrators group.
- COn Server1, assign the diskadmin and the setupadmin server roles to Admin1.
- DOn Server1, assign the dbcreator and the securityadmin server roles to Admin1.
How the community answered
(35 responses)- A6% (2)
- B11% (4)
- C3% (1)
- D80% (28)
Explanation
BURGOS MNEMO: "dbcreator" 2008-R2-and-SQL-Server-2008-R2-Part-5-Administrative-and-service-accounts.aspx
Topics
Community Discussion
No community discussion yet for this question.