James works as an Administrator for Softech Inc.
The company has a SQL Server 2005 computer named SQL1.
The company has six departments; Accounting, Sales, Marketing, Manufacturing, Production, and Research. The user accounts of each department are located in a domain group named after the department. James wants to create a separate database on SQL1 for each department which will store the department related information. Users in each department must be able to read and update data in the database belonging to their respective departments.
No user must be able to access the database belonging to another department.
James wants to configure access to the database to meet these requirements.
What should James do to accomplish the task?
A. James should create a Windows Authentication login for each domain group and configure the logins as database users for the appropriate database. Add each database user to the db_ddladmin database role.
B. James should create a Windows Authentication login for each domain group and configure the logins as database users for the appropriate database. Add each database user to the db_datareader and db_datawriter database roles.
C. James should create a Windows Authentication login for each domain user and configure the logins as database users for the appropriate database. Add each database user to the db_ddladmin database role.
D. James should create a Windows Authentication login for each domain user and configure the logins as database users for the appropriate database. Add each database user to the db_datareader and db_datawriter database roles.
How To Pass 98-364 Exam?FULL Printable PDF and Software. VALID exam to help you PASS. |
 |
