What should you recommend?

Correct Answer for the following Question is given below

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:

What should you recommend?

Options:

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

Use Basic authentication and set the Integrated Security property of the SQL Server connection string to SSPI.

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

Use Windows authentication and set the Trusted Connection property of the SQL Server connection string to true.

Correct Answer

The Correct Answer for this Question is

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

Explanation

The Question – What should you recommend? has been answered correctly and answers for the question is Use Windows authentication and impersonation to configure constrained delegation between servers.

More about these Exams

These Exam Questions and the order of these questions keep changing. but the answers are obviously same. so if you don’t find a question after another we suggest you search it in the search box and we are sure you’ll find it. you can bookmark this site for Quick access in future.

We hope you found it helpful don’t forget to leave a comment if you feel a need to correct or ask we’re always here to help.

you can find more here at mnccertified

Feel free to contact via comment or email.

Happy Learning

Cheers, Team MNCcertified