You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server database. The application uses DataContexts to query
the database.
The application meets the following requirements:
-Stores customer data offline.
-Allows users to update customer records while they are disconnected from the server.
-Enables offline changes to be submitted back to the SQL Server by using the DataContext object.
You need to ensure that the application can detect all conflicts that occur between the offline customer information submitted to the SQL Server and the server version. You also need to ensure that you can roll back local changes. What should you do?

• A. Add a try/catch statement around calls to the SubmitChanges method of the DataContext object and catch SqlExceptions.
• B. Override the Update operation of the DataContext object. Call the ExecuteDynamicUpdate method to generate the update SQL.
• C. Add a try/catch statement around calls to the SubmitChanges method of the DataContext object and catch ChangeConflictExceptions.
• D. Call the SubmitChanges method of the DataContext object. Pass System.Data.Linq.ConflictMode.ContinueOnConflict to the method.

How do you define a WCF Data Service query to grab the first 10 records. Options are something like:

• A. DataServiceQuery<Order> selectedOrders = context.Orders.AddQueryOption("$expand", "10");
• B. DataServiceQuery<Order> selectedOrders = context.Orders.AddQueryOption("$filter", "10");
• C. DataServiceQuery<Order> selectedOrders = context.Orders.AddQueryOption("$top", "10");
• D. DataServiceQuery<Order> selectedOrders = context.Orders.AddQueryOption("$select", "10");

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server database. The application uses the ADO.NET Entity
Framework to manage order data.
The application makes a Web service call to obtain orders from an order-tracking system.
You need to ensure that the orders are added to the local data store. Which method should you call on the
ObjectContext?

• A. Attach
• B. AttachTo
• C. ApplyCurrentValues
• D. AddObject

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows
Communication Foundation (WCF) Data Services service.
The service connects to a Microsoft SQL Server 2008 database. The service is hosted by an Internet
Information Services (IIS) 6.0 server.
You need to ensure that applications authenticate against user information stored in the database before
the application is allowed to use the service.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A. Configure IIS to require Windows authentication.
• B. Configure IIS to allow anonymous access.
• C. Modify the Data Services service to use a Microsoft ASP.NET membership provider.
• D. Enable the WCF Authentication Service.
• E. Configure IIS to require basic authentication.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server database. You load records from the Customers table
into a DataSet object named dataset.
You need to retrieve the value of the City field from the first and last records in the Customers table.
Which code segment should you use?

• A. DataTable dt = dataset.Tables["Customers"]; string first = dt.Rows[0]["City"].ToString(); string last = dt.Rows[dt.Rows.Count]["City"].ToString();
• B. DataRelation relationFirst = dataset.Relations[0]; DataRelation relationLast = dataset.Relations[dataset.Relations.Count - 1]; string first = relationFirst.childTable.Columns["City"].ToString(); string last = relationLast.childTable.Columns["City"].ToString();
• C. DataTable dt = dataset.Tables["Customers"]; string first = dt.Rows[0]["City"].ToString(); string last = dt.Rows[dt.Rows.Count - 1]["City"].ToString();
• D. DataRelation relationFirst = dataset.Relations[0]; DataRelation relationLast = dataset.Relations[dataset.Relations.Count]; string first = relationFirst.childTable.Columns["City"].ToString(); string last = relationLast.childTable.Columns["City"].ToString();