Q:
You plan to deploy your ASP.NET application over XYZ’s intranet. The application uses data retrieved from a Microsoft SQL Server database. You want to use SQL Server connection pooling to optimize performance. You also need to protect confidential data stored on the server while minimizing administrative costs.
You need to configure security for your application. What should you do?
Answer & Explanation
Answer: B) Use Microsoft Windows authentication in the application. Use a single Windows account for users to access the SQL Server database from your application.
Explanation: We should only use one account to access the SQL Server database. This ensures that connection pooling is optimized.
Incorrect Answers:
A: We should only use a single account to access the SQL Server database.
C: Form-based authentication is less secure. Furthermore, running as the System Administrator with the sa login would compromise security.
D: Form-based authentication is less secure. Furthermore, creating a separate SQL Server login for each user is a daunting administrative task.
View Answer
Report Error
Discuss
Aptitude and Reasoning
General Knowledge
Puzzles
Interviews
Technical
Certifications
Exams
Job
Roles
True or False
Exams