QUESTION NO: 1

You use Microsoft .NET Framework 4 to develop an application that connects to a Microsoft SQL Server 2008 database by using SQL Server 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 the Open method 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

Answer: C
Explanation:

QUESTION NO: 2

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You use the ADO.NET Entity Framework to model entities.

You write the following code segment. (Line numbers are included for reference only.)

01 Dim context As New AdventureWorksEntities("http://localhost:1234/AdventureWorks.svc") 02 03 Dim q As var = From c In context.Customers _

04 Where c.City ="London" _

05 Order By c.CompanyName _

06 Select c

92

You need to ensure that the application meets the following requirements:

- -

Compares the current values of unmodified properties with values returned from the data source Marks the property as modified when the properties are not the same MCTS Windows 7 Configuration

Which code segment should you insert at line 02?

A. context.MergeOption = MergeOption.AppendOnly

B. context.MergeOption = MergeOption.PreserveChanges

C. context.MergeOption = MergeOption.OverwriteChanges

D. context.MergeOption = MergeOption.NoTracking

Answer: B
Explanation: