nerdexam
Microsoft

70-516 · Question #60

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…

The correct answer is C. Persist Security Info = False. The Persist Security Info property specifies whether the data source can persist sensitive authentication information such as a password. Persist Security Info Property

Implementing Data Access

Question

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?

Options

  • APersist Security Info = True
  • BTrusted_Connection = True
  • CPersist Security Info = False
  • DTrusted_Connection = False

How the community answered

(15 responses)
  • A
    7% (1)
  • B
    13% (2)
  • C
    73% (11)
  • D
    7% (1)

Explanation

The Persist Security Info property specifies whether the data source can persist sensitive authentication information such as a password. Persist Security Info Property

Topics

#connection string#Persist Security Info#SqlConnection#credential security

Community Discussion

No community discussion yet for this question.

Full 70-516 Practice