nerdexam
Microsoft

70-519 · Question #125

An ASP.NET Web application connects to a Microsoft SQL Server 2008 database. Multiple users access the database. The Web.config file includes a database connection string. The Web application uses…

The correct answer is A. In the connection string, set the Integrated Security parameter to true. C. Do not explicitly close connections. See the full explanation below for the reasoning.

Question

An ASP.NET Web application connects to a Microsoft SQL Server 2008 database. Multiple users access the database. The Web.config file includes a database connection string. The Web application uses Windows authentication and impersonation. Anonymous access is turned off. You need to recommend an approach for pooling database connections between users. Which two actions should you recommend? (Each correct answer presents part of the solution. Choose two.)

Options

  • AIn the connection string, set the Integrated Security parameter to true.
  • BIn the connection string, specify a user name and password.
  • CDo not explicitly close connections.
  • DExplicitly close connections.

How the community answered

(61 responses)
  • A
    80% (49)
  • B
    8% (5)
  • D
    11% (7)

Community Discussion

No community discussion yet for this question.

Full 70-519 Practice