Exam Code: 70-451
Exam Name: PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008
You are a database developer. You develop a task management application that connects to a SQL Server 2008 database named TaskDB. Users log on to the application by using a SQL Server login. The application contains a module named Task that assigns tasks to users. Information about these tasks is stored in the Tasks table of the TaskDB database. The Tasks table contains multiple columns. These include the CloseDate and EstimatedTime columns.
– Users assigned to a database role named User1 can update all task information columns except the CloseDate and the EstimatedTime columns in the Tasks table.
– Administrative users assigned to a database role named Task_Admin can update all task information in the Tasks table.
You need to design a strategy to meet the security requirements. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A. Add the Task_Admin role to the db_accessadmin fixed database role.
B. Grant Update permissions on the Tasks table to the Task_Admin role.
C. Grant Update permissions on the Tasks table to the User1 role for each column except the CloseDate
and EstimatedTime columns.
D. Create an INSTEAD OF trigger on the Tasks Table. Use the Is_Member function to prevent the
User1 role from updating the CloseDate and EstimatedTime columns.
Correct Answer: BC