Question

You develop a Windows-Based application that accesses a Microsoft SQL Server database named ABC. Users must supply a user name and password when they start the application. This information is then used to dynamically build a connection string. When you test the application, you discover that it is not using the SqlClient connection pooling feature. You must reduce the time needed to retrieve information. How should you modify the connection string?

technology programming languages

to use the Windows user logon when connection to the TestKing1 database.
to use the SQL Server used login when connection to the TestKing1 database.
to use the same application logon ID and password for every connection to the TestKing1 database.
to use the guest login ID and password for every connection to the TestKing1 database.

Answer 1

Correct Option: C

Find more quizzes: