You use Microsoft .NET Framework 4.0 to develop an application that uses LINQ to SQL. The LINQ to SQL
model contains the Product entity.
A stored procedure named GetActiveProducts performs a query that returns the set of active products from
the database.
You need to invoke the stored procedure to return the active products, and you must ensure that the LINQ
to SQL context can track changes to these entities. What should you do?

• A. Navigate to the GetActiveProducts stored procedure in Server Explorer, and drag the procedure onto the Product entity in the LINQ to SQL model designer surface.
• B. Add a property named GetActiveProducts to the Product entity.
• C. Select the Product entity, view the entity's property window, and change the Source for the entity to GetActiveProducts.
• D. Select the Product entity, view the entity's property window, and change the Name for the entity to GetActiveProducts.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application uses the ADO.NET Entity Framework to model entities.
The application allows users to make changes to entities while disconnected from the central data store.
You need to ensure that when the user connects to the central data store and retrieves new data, the application meets the following requirements:
-Changes made to the local data store in disconnected mode are preserved.
-Entities that have already been loaded into the local data store, but have not been modified by the user,
are updated with the latest data. What should you do?

• A. Call the query's Execute method by using the MergeOptions.AppendOnly option.
• B. Call the query's Execute method by using the MergeOptions.OverwriteChanges option.
• C. Call the Refresh method of ObjectContext by using the RefreshMode.StoreWins option.
• D. Call the Refresh method of ObjectContext by using the RefreshMode.ClientWins option.

You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server
2008 database.
You need to ensure that the application connects to the database server by using SQL Server
authentication.
Which connection string should you use?

• A. SERVER=MyServer; DATABASE=AdventureWorks; Integrated Security=false;
• B. SERVER=MyServer; DATABASE=AdventureWorks; Trusted Connection=true;
• C. SERVER=MyServer; DATABASE=AdventureWorks; UID=sa; PWD=secret;
• D. SERVER=MyServer; DATABASE=AdventureWorks; Integrated Security=SSPI; UID=sa; PWD=secret;

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 DataContexts to
query the database.
You create a function that meets the following requirements:
-Updates the Customer table on the database when a customer is marked as deleted.
-Updates the related entries in other tables (CustomerAddress, CustomerContacts) by marking them as deleted.
-Prevents consumer code from setting the Deleted column's value directly.
You need to ensure that the function verifies that customers have no outstanding orders before they are
marked as deleted.
You also need to ensure that existing applications can use the update function without requiring changes in
the code.
What should you do?

• A. Override the Delete operation of the DataContext object.
• B. Modify the SELECT SQL statement provided to the DataContext object to use an INNER JOIN between the Customer and Orders tables.
• C. Override the Update operation of the DataContext object.
• D. Add new entities to the DataContext object for the Customers and Orders tables.