70-454 MCITP Braindump
ExamSoon 70-454 Exams
Microsoft UPG: Transiton MCITP SQL Serv 2005 to SQL Serv 2008 DBD
O rder : 70-454 Exam
Practice Exam: 70-454
Exam Number/Code: 70-454
Exam Name: UPG: Transiton MCITP SQL Serv 2005 to SQL Serv 2008 DBD
Questions and Answers: 41 Q&As
Free 70-454 Braindumps
Exam : Microsoft 70-454
Title : UPG: Transiton MCITP SQL Serv 2005 to SQL Serv 2008 DBD
1. 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.
The application must meet the following security requirements:
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.
Answer: BC
2. You are creating a function that references a table.
You need to prevent the table from being dropped.
Which option should you use when you create the function?
A. WITH ENCRYPTION
B. WITH EXECUTE AS
C. WITH SCHEMABINDING
D. WITH RETURNS NULL ON