70-516 · Question #141
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…
The correct answer is A. Data Source=myServerAddress; Initial Catalog=myDataBase; Integrated Security=SSPI. 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…
Question
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. When a connection fails, the application logs connection information, including the full connection string. The information is stored as plain text in a .config file. You need to ensure that the database credentials are secure. Which connection string should you add to the .config file?
Options
- AData Source=myServerAddress; Initial Catalog=myDataBase; Integrated Security=SSPI;
- BData Source=myServerAddress; Initial Catalog=myDataBase; Integrated Security=SSPI;
- CData Source=myServerAddress; Initial Catalog=myDataBase; User Id=myUsername;
- DData Source=myServerAddress; Initial Catalog=myDataBase; User Id=myUsername;
How the community answered
(23 responses)- A78% (18)
- B4% (1)
- C13% (3)
- D4% (1)
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 Recognized values are true, false, yes, and no.
Topics
Community Discussion
No community discussion yet for this question.