testking question

microsoft.public.sqlserver.programming

2 Jun 2005 5:50 AM

ichor

hi
in the question below why is C the right answer?

doesnt the question say that the CSR and the Marketing employees need
Select, insert and update permission?
so basically both types of users need an overall access?

17. (17) You are designing your Company's SQL Server 2000 sales database,
which will be accessed by a custom application. Customer service and
marketing employees require SELECT, INSERT, and UPDATE permissions on all
tables in the Sales database. In addition to using the custom application,
the marketing employees will use Microsoft Excel to retrieve data from the
sales database to create charts.

Customer service employees belong to Microsoft Windows 2000 group named CSR,
and marketing employees belong to a Windows 2000 group named Marketing. You
want the customer service employees to access the sales database only from
within the custom application. You want to allow the marketing employees to
use both the custom application and Excel to access the sales database. No
permissions have been granted in the database. What should you do?

A. Create a database role named Marketing for the marketing employees and a
database role named customer service for the customer service employees. Add
the Windows 2000 groups to the user-defined database roles. Grant SELECT
permissions on all tables in the database to the marketing database role.
Grant SELECT, INSERT, and UPDATE permissions on all tables in the database
to the Customer Service database role.
B. Create one application role to be used by both the customer service and
marketing employees. Grant SELECT permissions on all tables in the database
to the Windows 2000 marketing group. Grant SELECT, INSERT, and UPDATE
permissions on all tables in the database to the Windows 2000 CSR group.
C. Create an application role for the custom application. Grant SELECT,
INSERT and UPDATE permissions to the application role. Create a database
role named Marketing for the marketing employees. Add the Windows 2000
Marketing group to the Marketing database role. Grant SELECT permissions on
all tables in the database to the marketing database role.
D. Create one application role for the customer service employees. Create a
second application role for the marketing employees. Grant SELECT
permissions on all tables in the database to the application role to be used
by the marketing employees. Grant SELECT, INSERT, and UPDATE permissions on
all tables in the database to the application role to be used by the
customer service employees.
E. Create one application role for the customer service employees. Create a
second application role for the marketing employees to access the sales
database by using the custom application. Create a third application role
for the marketing employees to use when retrieving data from Excel. Grant
SELECT permissions on all tables in the database to both application roles
to be used by the marketing employees. Grant SELECT, INSERT, and UPDATE
permissions on all tables in the database to the application role to be used
buy the customer service employees.

Ans:C

2 Jun 2005 2:27 PM

John Bell

Hi

The question is badly worded Customer Service and Marketing employess access
the database through a custom application that requires SELECT, INSERT and
UPDATE privileges to all tables. The marketing department also use Excel to
create charts from data in the sales database.

Answer C stops Customer Services and Marketing using Access or Excel to
update the database but allows the custom application to work correctly by
anyone who uses it.

John

Show quoteHide quote

"ichor" <ic***@hotmail.com> wrote in message
news:%23ZB6IczZFHA.796@TK2MSFTNGP09.phx.gbl...
> hi
> in the question below why is C the right answer?
>
> doesnt the question say that the CSR and the Marketing employees need
> Select, insert and update permission?
> so basically both types of users need an overall access?
>
>
>
> 17. (17) You are designing your Company's SQL Server 2000 sales database,
> which will be accessed by a custom application. Customer service and
> marketing employees require SELECT, INSERT, and UPDATE permissions on all
> tables in the Sales database. In addition to using the custom application,
> the marketing employees will use Microsoft Excel to retrieve data from the
> sales database to create charts.
>
>
>
> Customer service employees belong to Microsoft Windows 2000 group named
> CSR, and marketing employees belong to a Windows 2000 group named
> Marketing. You want the customer service employees to access the sales
> database only from within the custom application. You want to allow the
> marketing employees to use both the custom application and Excel to access
> the sales database. No permissions have been granted in the database. What
> should you do?
>
>
>
> A. Create a database role named Marketing for the marketing employees and
> a database role named customer service for the customer service employees.
> Add the Windows 2000 groups to the user-defined database roles. Grant
> SELECT permissions on all tables in the database to the marketing database
> role. Grant SELECT, INSERT, and UPDATE permissions on all tables in the
> database to the Customer Service database role.
> B. Create one application role to be used by both the customer service and
> marketing employees. Grant SELECT permissions on all tables in the
> database to the Windows 2000 marketing group. Grant SELECT, INSERT, and
> UPDATE permissions on all tables in the database to the Windows 2000 CSR
> group.
> C. Create an application role for the custom application. Grant SELECT,
> INSERT and UPDATE permissions to the application role. Create a database
> role named Marketing for the marketing employees. Add the Windows 2000
> Marketing group to the Marketing database role. Grant SELECT permissions
> on all tables in the database to the marketing database role.
> D. Create one application role for the customer service employees. Create
> a second application role for the marketing employees. Grant SELECT
> permissions on all tables in the database to the application role to be
> used by the marketing employees. Grant SELECT, INSERT, and UPDATE
> permissions on all tables in the database to the application role to be
> used by the customer service employees.
> E. Create one application role for the customer service employees. Create
> a second application role for the marketing employees to access the sales
> database by using the custom application. Create a third application role
> for the marketing employees to use when retrieving data from Excel. Grant
> SELECT permissions on all tables in the database to both application roles
> to be used by the marketing employees. Grant SELECT, INSERT, and UPDATE
> permissions on all tables in the database to the application role to be
> used buy the customer service employees.
>
> Ans:C
>
>