You use Microsoft Visual Studio 2010 to create a Microsoft .NET Framework 4.0 application. You create an Entity Data Model for the database tables shown in the following diagram.

You need to modify the .edmx file so that a many-to-many association can exist between the Address and
Customer entities.
Which storage Model section of the .edmx file should you include?

• A. <EntityType Name="CustomerAddress">
  <Key>
  <PropertyRef Name="CustomerID" />
  <PropertyRef Name="AddressID" />
  </Key>
  <Property Name="CustomerID" Type="int" Nullable="false" />
  <Property Name="AddressID" Type="int" Nullable="false" />
  <Property Name="AddressType" Type="nvarchar" Nullable="false" MaxLength="50"
  DefaultValue="Home" />
  </EntityType>
• B. <EntityType Name="CustomerAddress">
  <Key>
  <PropertyRef Name="CustomerAddressID" />
  <PropertyRef Name="CustomerID" />
  <PropertyRef Name="AddressID" />
  </Key>
  <Property Name="CustomerAddressID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" /
  >
  <Property Name="CustomerID" Type="int" Nullable="false"/>
  <Property Name="AddressID" Type="int" Nullable="false"/>
  <Property Name="AddressType" Type="nvarchar" Nullable="false" MaxLength="50"/>
  </EntityType>
• C. <EntityType Name="CustomerAddress"> <Key>
  <PropertyRef Name="CustomerAddressID" /> </Key> <Property Name="CustomerAddressID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" /
  >
  <Property Name="CustomerID" Type="int" Nullable="false"/>
  <Property Name="AddressID" Type="int" Nullable="false" />
  <Property Name="AddressType" Type="nvarchar" Nullable="false" MaxLength="50"/>
  </EntityType>
• D. <EntityType Name="CustomerAddress">
  <Key>
  <PropertyRef Name="CustomerID" />
  <PropertyRef Name="AddressID" />
  </Key>
  <Property Name="CustomerID" Type="int" Nullable="false"/>
  <Property Name="AddressID" Type="int" Nullable="false"/>
  <Property Name="AddressType" Type="nvarchar" Nullable="false" MaxLength="50" />
  </EntityType>

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 use Entity SQL to retrieve data from the
database.
You need to enable query plan caching. Which object should you use?

• A. EntityConnection
• B. EntityTransaction
• C. EntityCommand
• D. EntityDataReader

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to develop an application. A file named books.xml contains the following XML.
<bib>
<book title="Programming in Unix" year="1992">
<author>Author1</author>
<author>Author2</author>
<author> Author 3 </author>
</book> </bib>
The application must generate an XML result that contains an XML element named BookTitle for each
book. The text content of the element must contain the title of the book.
You need to create a query that generates the new XML result. What should you do?

• A. XDocument document = XDocument.Load("books.xml");
  var query = from node in document.DescendantNodes()
  where node.ToString() == "book"
  select new XElement("BookTitle", node.ToString());
• B. XDocument document = XDocument.Load("books.xml");
  var query = from node in document.DescendantNodes()
  where node.ToString() == "book"
  select new XText("BookTitle" + node.ToString());
• C. XDocument document = XDocument.Load("books.xml");
  var query = from node in document.Descendants()
  where node.Name.LocalName == "book"
  select new XElement("BookTitle", node.FirstAttribute.Value);
• D. XDocument document = XDocument.Load("books.xml");
  var query = from node in document.Descendants()
  where node.Name.LocalName == "book"
  select new XElement("BookTitle").Value = node.FirstAttribute.Value;

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application.
You use the ADO.NET Entity Framework Designer to model entities. The application includes two
ObjectContext instances named context1 and context2.
You need to persist the changes in both object contexts within a single transaction. Which code segment
should you use?

• A. using (TransactionScope scope = new TransactionScope()) { using (TransactionScope scope1 = new TransactionScope (TransactionScopeOption.RequireNew))
  {
  context1.SaveChanges();
  scope1.Complete();
  }
  using (TransactionScope scope2 = new TransactionScope
  (TransactionScopeOption.RequireNew))
  {
  context2.SaveChanges();
  scope2.Complete();
  }
  scope.Complete();
  }
• B. using (TransactionScope scope = new TransactionScope()) { using (TransactionScope scope1 = new TransactionScope (TransactionScopeOption.RequireNew)) {
  context1.SaveChanges();
  }
  using (TransactionScope scope2 = new TransactionScope
  (TransactionScopeOption.RequireNew))
  {
  context2.SaveChanges();
  }
  }
• C. using (TransactionScope scope = new TransactionScope())
  {
  context1.SaveChanges();
  context2.SaveChanges();
  }
• D. using (TransactionScope scope = new TransactionScope())
  {
  context1.SaveChanges();
  context2.SaveChanges();
  scope.Complete();
  }