1.

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._x005F_x000D_  _x005F_x000D_ You need to configure security for your application. What should you do?

A. Use Microsoft Windows authentication in the application. Enable impersonation for users to access the SQL Server database from your application.
B. Use Microsoft Windows authentication in the application. Use a single Windows account for users to access the SQL Server database from your application.
C. Use form-based authentication in the application. Use the system administrator (sa) SQL Server login for users to access the SQL Server database from your application.
D. Use form-based authentication in the application. Assign each user a separate SQL Server login to use to access the SQL Server database from your application.
Answer» C. Use form-based authentication in the application. Use the system administrator (sa) SQL Server login for users to access the SQL Server database from your application.


Discussion

No Comment Found

Related MCQs