You are designing an ASP.NET Web application that stores data in a Microsoft SQL Server 2008 database on a remote server. You must meet the following requirements:

Ensure that users' actions can be traced on each server by using the

security audit log.

Minimize the risk of server components executing in the user's

context. You need to recommend an approach for accessing the database. What should you recommend?

Question

You are designing an ASP.NET Web application that stores data in a Microsoft SQL Server 2008 database on a remote server. You must meet the following requirements:

Ensure that users' actions can be traced on each server by using the

security audit log.

Minimize the risk of server components executing in the user's

context. You need to recommend an approach for accessing the database. What should you recommend?

Accepted Answer

D. Use Windows authentication and impersonation to configure constrained delegation between

Answer

A. Use Basic authentication and set the Integrated Security property of the SQL Server

Answer

B. Use Basic authentication and impersonation to configure a trusted subsystem between

Answer

C. Use Windows authentication and set the Trusted Connection property of the SQL Server

You are designing an ASP.NET Web application that stores data in a Microsoft SQL Server 2008 database on a remote server. You must meet the following requirements: - Ensure that users' actions can…

Question

Options

How the community answered

Community Discussion