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?
A.
Use Basic authentication and set the Integrated Security property of the SQL Server
connection string to SSPI.
B.
Use Basic authentication and impersonation to configure a trusted subsystem between
servers.
C.
Use Windows authentication and set the Trusted Connection property of the SQL Server
connection string to true.
D.
Use Windows authentication and impersonation to configure constrained delegation
between servers.