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. from person in model.SalesPersons group person by person.SalesTerritory into territoryByPerson select new {
  SalesTerritory = territoryByPerson.Key,
  TotalBonus = territoryByPerson.Sum(person => person.Bonus)
  };
• B. model.SalesPersons .GroupBy(person => person.SalesTerritory) .SelectMany(group => group.Key.SalesPersons) .Sum(person => person.Bonus);
• C. model.SalesTerritories .GroupBy(territory => territory.SalesPersons) .SelectMany(group => group.Key) .Sum(person => person.Bonus);
• D. from territory in model.SalesTerritories group territory by territory.SalesPerson into personByTerritories select new {
  SalesTerritory = personByTerritories.Key,
  TotalBonus = personByTerritories.Key.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 database.
The Data Definition Language (DDL) script of the database contains the following code segment:
CREATE TABLE [Sales].[SalesOrderHeader]( [SalesOrderID] [int] IDENTITY(1,1) NOT NULL, [BillToAddressID] [int] NOT NULL, ... CONSTRAINT [PK_SalesOrderHeader_SalesOrderID] PRIMARY KEY CLUSTERED ([SalesOrderID] ASC) )
ALTER TABLE [Sales].[SalesOrderHeader] WITH CHECK ADD CONSTRAINT [FK_SalesOrderHeader_Address] FOREIGN KEY([BilIToAddressID]) REFERENCES [Person].[Address]([AddressID])
You create an ADO.NET Entity Framework model. You need to ensure that the entities of the model
correctly map to the DDL of the database.
What should your model contain?

• A. Option
• B. Option
• C. Option
• D. Option

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to several SQL Server databases. You create a function that modifies customer
records that are stored in multiple databases.
All updates for a given record are performed in a single transaction. You need to ensure that all transactions
can be recovered.
What should you do?

• A. Call the EnlistDurable method of the Transaction class.
• B. Call the EnlistVolatile method of the Transaction class.
• C. Call the RecoveryComplete method of the TransactionManager class.
• D. Call the Reenlist method of the TransactionManager class.

You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server
200B database.
You populate a SqlDataAdapter by using the following code. (Line numbers are included for reference only.)
01 SqlDataAdapter dataAdapter1 = new SqlDataAdapter("SELECT * FROM
[BlogEntries] ORDER BY CreationDate", connection);
02 cmdBuilder = new SqlCommandBuilder(dataAdapter1);
03 dataAdapter1.Fill(BlogEntryDataSet, "BlogEntries");
04 ....
05 connection.Close();
You need to update the blog owner for all BlogEntry records. Which code segment should you insert at line 04?

• A. foreach(DataRow row in BlogEntryDataSet.Tables["BlogEntries"].Rows) {
  row.Item["BlogOwner""] = "New Owner";
  }
  dataAdapter1.Update(BlogEntryDataSet, "BlogEntries");
• B. SqlDataAdapter dataAdapter2 = new SqlDataAdapter("UPDATE [BlogEntries] SET [BlogOwner] = "New
  'Owner' 3", connection);
  dataAdapter2.Update(BlogEntryDataSet, "BlogEntries");
• C. SqlDataAdapter dataAdapter2 = new SqlDataAdapter(dataAdapterl.UpdateCommand); dataAdapter2.Fill(BlogEntryDataSet, "BlogEntries");
• D. foreach(DataRow row in BlogEntryDataSet.Tables["BlogEntries"].Rows) {
  row.Item["BlogOwner""] = "New Owner";
  }
  dataAdapter1.Fill(BlogEntryDataSet, "BlogEntries");