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?
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)