You create Microsoft Windows-based applications. You need to evaluate the design concept of an application.
The application must meet the following requirements:
The application relies on the operating system for authentication. The application minimizes the amount of data sent over the network when connecting to the database. The application exposes data access code so that the future Web-based and mobile applications can reuse them.
The application permits users to view and edit data contained in tables from a Microsoft SQL Server 2005 database.
The application controls access to the SQL Server 2005 database at the table level.
The design contains the following elements:
The SQL Server 2005 database uses the Windows Authentication mode. A database schema that grants rights to the users at the table level. A stored procedure in Transact-SQL that accesses the necessary data required by the application. A Web service that uses a pre-defined credential to access the database and run the stored procedures. A Microsoft Windows-based application that impersonates the logged-on user and calls the Web service to retrieve and update the data.
You need to evaluate the design and recommend appropriately. What should you recommend?
A.
The design meets all the requirements.
B.
Change the Windows-based application to use Windows Authentication.
C.
Change the Web service to impersonate the caller.
D.
Change the database schema to use stored procedures in C#.