안녕하세요 ^^
다음주에 70-229 를 시험볼예정입니다
덤프를 풀다가 잘 이해가 가질 않아서요
You are a member of a database development team for a telecommunications company. Another developer on the team, Marc, has created a table named Customers in the Corporate database.
Because the table contains confidential information, he has granted SELECT permissions on the table only to the other members of your team. You are developing an application that will allow employees in the marketing department to view some of the information in the Customers table. These employees are all members of the Marketing database role.
To support this application, you create a view named vwCustomers on the Customers table.
After creating the view, you grant SELECT permissions on the view to the Marketing role.
When members of the Marketing role attempt to retrieve data from the view, they receive the following error message: SELECT permission denied on object ‘Customers’, database ‘Corporate’, owner ‘Marc’.
You must ensure that the members of the Marketing role can only use the vwCustomers view to access the data in the Customers table. What should you do? A. Add the marketing role to the sysadmin fixed server role. B. Transfer the ownership of the vwCustomers view to the marketing role. C. Instruct Marc to transfer the ownership of the Customers table to each member of the marketing role. D. Instruct Marc to grant the users SELECT permissions on the Customers table. E. Drop the vwCustomers view. Instruct Marc to re-create the view and to grant SELECT permissions on the view to the marketing role.
문제입니다 고수님들좀 이 문제에 대해서 아르켜주세요 답은 E 입니다 |