You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run on Windows Server2003 while half the client computers run Windows XP Professional and the rest run UNIX. The Domain.com network contains a SQL Server 2000 database server named Certkiller -DB01 that runs on Windows 2000 Server. Certkiller -DB01 contains a database named CK_DB.
All Domain.com users will require access to the CK_DB database from the corporate network. You need to configure access to the CK_DB database to meet these requirements. You want to use the least amount of administrative effort in accomplishing this task.
What should you do?
A.
Configure the CK_DB database to support Mixed Mode Authentication. Create a SQL login for the Domain Users group. Create SQL logins with passwords for each UNIX user.
B.
Configure the CK_DB database to support Windows Authentication. Create a SQL login for each domain user.
C.
Configure the CK_DB database to support Mixed Mode Authentication. Create a SQL login for each domain user.
D.
Configure the CK_DB database to support Windows Authentication. Create a SQL login for the Domain Users group.
Explanation:
You need to use Mixed Mode Authentication to allow access to the database for the UNIX users. Each UNIX user will require a SQL login with a password. The Windows XP Professional users can be granted access collectively by granting the Domain Users group access to the database.
Incorrect Answers:
B, D: You cannot use Windows Authentication as this will not allow the UNIX users to access the database.
C: You can create a SQL login for each user but it would require less administrative effort t to create a SQL Login for the Domain Users group and separate SQL Logins for the UNIX users.