You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
uses the Entity Framework.
The application has an entity model that includes SalesTerritory and SalesPerson entities as shown in the
following diagram.

You need to calculate the total bonus for all sales people in each sales territory. Which code segment should you use?

• A. model.SalesPersons .GroupBy(person => person.SalesTerritory) .SelectMany(group => group.Key.SalesPersons) .Sum(person => person.Bonus);
• B. model.SalesTerritories .GroupBy(territory => territory.SalesPersons) .SelectMany(group => group.Key) .Sum(person => person.Bonus);
• C. from territory in model.SalesTerritories group territory by territory.SalesPerson into personByTerritories select new {
  SalesTerritory = personByTerritories.Key,
  TotalBonus = personByTerritories.Key.Sum(person => person.Bonus)
  };
• D. from person in model.SalesPersons group person by person.SalesTerritory into territoryByPerson select new {
  SalesTerritory = territoryByPerson.Key,
  TotalBonus = territoryByPerson.Sum(person => person.Bonus)
  };

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 database includes a table that
contains information about all the employees.
The database table has a field named EmployeeType that identifies whether an employee is a Contractor or
a Permanent employee.
You declare the Employee entity base type. You create a new Association entity named Contractor that
inherits the Employee base type.
You need to ensure that all Contractors are bound to the Contractor class. What should you do?

• A. Use the Entity Data Model Designer to set up a referential constraint between the primary key of the Contractor class and EmployeeType.
• B. Modify the .edmx file to include the following line of code: <Condition ColumnName="EmployeeType" Value="Contractor" />
• C. Modify the .edmx file to include the following line of code: <NavigationProperty Name="Type" FromRole="EmployeeType" ToRole="Contractor" />
• D. Use the Entity Data Model Designer to set up an association between the Contractor class and EmployeeType.

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. PUT /Northwind.svc/Customers(123) Host: contoso.com Accept: application/json { City: 'Seattle' }
• B. MERGE /Northwind.svc/Customers(123) Host: contoso.com
  Content-Type: application/json { City: 'Seattle' }
• C. MERGE /Northwind.svc/Customers(123) Host: contoso.com Accept: application/json { City: 'Seattle' }
• D. PUT /Northwind.svc/Customers(123) Host: contoso.com Content-Type: application/json { City: 'Seattle' }

You use Microsoft .NET Framework 4.0 to develop an application that exposes a WCF Data Services
endpoint.
The endpoint uses an authentication scheme that requires an HTTP request that has the following header
format.
GET /OData.svc/Products(1)
Authorization: WRAP access_token "123456789"
You add the following method to your DataService implementation.
01 protected override void OnStartProcessingRequest(ProcessRequestArgs args)
02 {
03 ....
04 }
You need to ensure that the method retrieves the authentication token. Which line of code should you use?

• A. string token = args.OperationContext.RequestHeaders["Authorization"];
• B. string token = args.OperationContext.ResponseHeaders["Authorization"];
• C. string token = args.OperationContext.ResponseHeaders["WRAP access_token"];
• D. string token = args.OperationContext.RequestHeaders["WRAP access_token"];

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. You add the following store procedure
to the database.
CREATE PROCEDURE GetProducts AS BEGIN
SELECT ProductID, Name, Price, Cost FROM Product END
You create a SqlDataAdapter named adapter to execute the stored procedure. You need to fill a DataTable
instance with the first 10 rows of the result set.
What are two possible code segments that you can use to achieve the goal?

• A. DataSet ds = new DataSet(); ds.ExtendedProperties["RowCount"] = 10; ds.ExtendedProperties["RowIndex"] = 0; adapter.Fill(ds);
• B. DataSet ds = new DataSet(); DataTable dt = ds.Tables.Add("Product"); adapter.Fill(0, 10, dt);
• C. DataSet ds = new DataSet(); DataTable dt = ds.Tables.Add("Product"); dt.ExtendedProperties["RowCount"] = 10; dt.ExtendedProperties["RowIndex"] = 0; adapter.Fill(dt);
• D. DataSet ds = new DataSet(); adapter.Fill(ds, 0, 10, "Product");