You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server 2008 database. The application uses a Microsoft ADO.NET SQL Server managed provider.
“Data Source=myServerAddress; Initial Catalog=myDataBase; User Id=myUsername; Password=secret;”
You need to ensure that the database credentials are secure. Which is the correct Property to insert?
A.
Integrated Security=SSPI;
B.
Persist Security Info=true;
C.
Persist Security Info=false;
D.
Integrated Security=false;
Explanation:
Persist Security Info
Default: ‘false’When set to false or no (strongly recommended), security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open state.
Resetting the connection string resets all connection string values including the password.Recognized values are true, false, yes, and no.
SSPI
(http://msdn.microsoft.com/en-us/library/windows/desktop/aa380493(v=vs.85).aspx)