Microsoft
98-364 · Question #30
98-364 Question #30: Real Exam Question with Answer & Explanation
Sign in or unlock 98-364 to reveal the answer and full explanation for question #30. The question stem and answer options stay visible for context.
Question
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 epartment 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?
Options
- AJames should create a Windows Authentication login for each domain group and configure
- BJames should create a Windows Authentication login for each domain group and configure
- CJames should create a Windows Authentication login for each domain user and configure
- DJames should create a Windows Authentication login for each domain user and configure
Unlock 98-364 to see the answer
You've previewed enough free 98-364 questions. Unlock 98-364 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.