Which action should you take?

You are a database administrator on an instance of SQL Server 2008. You maintain a database named Prod that contains information on products manufactured by your company, including product assemblies, bills of materials, work order information, and related component and finished-goods inventory information.
Employees in the inventory department use a custom ASP.NET application to manage the details about products that are received in inventory and finished goods that are transferred from inventory locations to fill and ship customer orders.
Employees in the assembly department access bills of materials, update component inventories, and update work order status in the database using a Windows Forms application.
You want to minimize administrative effort, ensure that employees can only access the necessary data in the Prod database, and prevent users from directly querying database tables.
Which action should you take?
A. Create an application role for each department. Add each employee to the appropriate application role.
B. Create a view to be used by each application. Grant each application permission to use the appropriate view.
C. Create an application role for each department, assign each departmental application role the required permissions, and code each application to authenticate users and activate the appropriate application role
D. Create a database role for each department, assign the required object permissions to each database role, and add each employee to the appropriate database role.

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.