Microsoft
70-519 · Question #248
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…
Sign in or unlock 70-519 to reveal the answer and full explanation for question #248. The question stem and answer options stay visible for context.
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?
Options
- AUse Windows authentication and set the Trusted Connection property of the SQL Server
- BUse Basic authentication and set the Integrated Security property of the SQL Server
- CUse Basic authentication and impersonation to configure a trusted subsystem between
- DUse Windows authentication and impersonation to configure constrained delegation
Unlock 70-519 to see the answer
You've previewed enough free 70-519 questions. Unlock 70-519 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.