nerdexam
Microsoft

70-516 · Question #44

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.N

The correct answer is C. Persist Security Info=false;. 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 Resetting the connection string resets all connecti

Implementing Data Access

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. "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?

Options

  • AIntegrated Security=SSPI;
  • BPersist Security Info=true;
  • CPersist Security Info=false;
  • DIntegrated Security=false;

How the community answered

(26 responses)
  • A
    4% (1)
  • B
    8% (2)
  • C
    73% (19)
  • D
    15% (4)

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 Resetting the connection string resets all connection string values including the password. Recognized values are true, false, yes, and no.

Topics

#connection string#Persist Security Info#credential security#SQL Server

Community Discussion

No community discussion yet for this question.

Full 70-516 Practice