PrepAway - Latest Free Exam Questions & Answers

What should you add to the connection string?

You use Microsoft .NET Framework 4 to develop an application that connects to a Microsoft SQL
Server 2008 database by using SQL Server authentication. The application contains the following
connection string. SERVER=DBSERVER-01; DATABASE=pubs; uid=sa; pwd=secret; You need to
ensure that the password value in the connection string property of a SqlConnection object does not
exist after the Open method is called. What should you add to the connection string?

PrepAway - Latest Free Exam Questions & Answers

A.
Persist Security Info=True

B.
Trusted_Connection=True

C.
Persist Security Info=False

D.
Trusted_Connection=False

Explanation:
The Persist Security Info property specifies whether the data source can persist sensitive
authentication information such as a password.
Persist Security Info Property
(http://msdn.microsoft.com/en-us/library/aa214039(v=sql.80).aspx)


Leave a Reply