You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows
Communication
Foundation (WCF) Data Services service. You deploy the data service to the following URL: http://
contoso.com/Northwind.svc.
You need to update the City property of the Customer record that has its ID value as 123.
You also need to preserve the current values of the remaining properties. Which HTTP request should you
use?

• A. MERGE /Northwind.svc/Customers(123) Host: contoso.com Accept: application/json { City: 'Seattle' }
• B. PUT /Northwind.svc/Customers(123) Host: contoso.com Accept: application/json { City: 'Seattle' }
• C. MERGE /Northwind.svc/Customers(123) Host: contoso.com
  Content-Type: application/json { City: 'Seattle' }
• D. PUT /Northwind.svc/Customers(123) Host: contoso.com Content-Type: application/json { City: 'Seattle' }

You use Microsoft Visual Studio 2010, Microsoft Sync Framework, and Microsoft .NET Framework 4.0 to
create an application.
You have a ServerSyncProvider connected to a Microsoft SQL Server database. The database is hosted on
a Web server.
Users will use the Internet to access the Customer database through the ServerSyncProvider.
You write the following code segment. (Line numbers are included for reference only.)
01 SyncTable customerSyncTable = new SyncTable("Customer");
02 customerSyncTable.CreationOption =
TableCreationOption.UploadExistingOrCreateNewTable;
03 ...
04 customerSyncTable.SyncGroup = customerSyncGroup;
05 this.Configuration.SyncTables.Add(customerSyncTable);
You need to ensure that the application meets the following requirements:
-Users can modify data locally and receive changes from the server.
-Only changed rows are transferred during synchronization. Which code segment should you insert at line 03?

• A. customerSyncTable.SyncDirection = SyncDirection.UploadOnly;
• B. customerSyncTable.SyncDirection = SyncDirection.Snapshot;
• C. customerSyncTable.SyncDirection = SyncDirection.Bidirectional;
• D. customerSyncTable.SyncDirection = SyncDirection.DownloadOnly;

A performance issue exists in the application. The following code segment is causing a performance bottleneck:
var colors = context.Parts.GetColors();
You need to improve application performance by reducing the number of database calls. Which code segment should you use?

• A. var colors = context.Parts.OfType<Product>().Include("Colors").GetColors();
• B. var colors = context.Parts.OfType<Product>().Include("Color").GetColors();
• C. var colors = context.Parts.OfType<Product>().Include ("Parts.Color").GetColors();
• D. var colors = context.Parts.OfType<Product>().Include ("Product.Color").GetColors();

You use Microsoft .NET Framework 4.0 to develop an ASP.NET application. The application uses
Integrated Windows authentication.
The application accesses data in a Microsoft SQL Server 2008 database that is located on the same server
as the application.
You use the following connection string to connect to the database.
Integrated Security=SSPI; Initial Catalog=AdventureWorks;
The application must also execute a stored procedure on the same server on a database named pubs.
Users connect to the ASP.NET application through the intranet by using Windows-based authentication.
You need to ensure that the application will use connection pooling whenever possible and will keep the
number of pools to a minimum.
Which code segment should you use?

• A. command.CommandText = "exec uspLoginAudit;"; using (SqlConnection connection = new SqlConnection( "Integrated Security=SSPI; Initial Catalog=pubs")) {
  connection.Open();
  command.ExecuteNonQuery();
  }
• B. command.CommandText = "USE [pubs]; exec uspLoginAudit;"; using (SqlConnection connection = new SqlConnection( "Integrated Security=SSPI; Initial Catalog=AdventureWorks")) {
  connection.Open();
  command.ExecuteNonQuery();
  }
• C. command.CommandText = "USE [pubs]; exec uspLoginAudit;"; using (SqlConnection connection = new SqlConnection( "Initial Catalog=AdventureWorks; Integrated Security=SSPI; MultipleActiveResultSets=True")) {
  connection.Open();
  command.ExecuteNonQuery();
  }
• D. command.CommandText = "exec uspLoginAudit;";
  using (SqlConnection connection = new SqlConnection( "Integrated Security=SSPI;")) {
  connection.Open();
  command.ExecuteNonQuery();
  }

You use Microsoft Visual Studio 2010 and .NET Framework 4.0 to develop an application that uses the Entity Data Model for the fallowing database tables.

You need to ensure that the entity that is mapped to the ContectTypeDerived table derives from the entity that is mapped to the ContentTypeBase table. What should you do?

• A. Use a Table-Per-Hierarchy mapping method.
• B. Use a Table-Per-Type mapping method.
• C. Create a complect type for each entity.
• D. Create a function import for each entity.