These questions are based on: 70-229 – Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition Microsoft Self-Test Software Practice Test.
Objective: Programming business logic
SubObjective: Manage data manipulation by using stored procedures, transactions, triggers, user-defined functions and views
Item No. 70-184.108.40.206
Single Answer, Multiple Choice
You are a database developer for a large political action association. Each constituent is assigned to the appropriate state and congressional district based on the constituent’s address. The association’s home page displays bulletins that are customized for each state or congressional district. When a constituent logs on to the Web site, the home page identifies the constituent’s address and displays the appropriate political bulletins.
The bulletins are stored in a table named Bulletins, which is in a database named Politics. The script that was used to create the Bulletins table is shown in the exhibit. (Click the Exhibit(s) button.)
Constituents need to view data in the Bulletins table, but they do not need to insert, update or delete data in the table. You need to deliver only the appropriate data to the Web site, based on the constituent’s address. Constituents only have permission to view bulletins for their area.
What should you do?
- Grant SELECT permissions on the Bulletins table for each state and congressional district.
- Grant SELECT permissions on the CongDist and State columns for each state and congressional district.
- Create a stored procedure that returns the rows that apply…
Please log in or subscribe to read this article