You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that connects
to a MS SQL server 2008 database by User 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 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)