Which two actions should you perform?

You work in an International company named TAKEEEN. And you’re in charge of the database of your company. There’s a SQL Server 2008 database named TaskDB. A task management application which contains a module named Task is created to connect to the database. Users use a SQL Server login to log on to the application. The module assigns tasks to users. There is a Tasks table in the TaskDB database which stores the information about these tasks. Multiple columns are contained in the Tasks table, including the CloseDate and EstimatedTime columns.
Look at the following requirements for the application:
• 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.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.