Refer to the following lines in the case study: PA40 in \Model\Part.cs, PR16 in\Model\Product.cs, and CT14 in \Model\Component.cs
The application must create XML files that detail the part structure for any product. The XML files must use the following format:
<?xml version="1.0" encoding="utf-8"?>
<product name="Brush" description="Brush product" productType="1">
<component name="Handle" description="Handle" partType="2">
<component name="Screw" description="Screw" partType="3">
<component name="Wood" description="Wooden shaft" partType="45">
</component>
<component name="Head" description="Head" partType="5">
<component name="Screw" description="Screw" partType="3">
<component name="Bristles" description="Bristles" partType="4">
</component> </product>
You need to update the application to support the creation of an XElement object having a structure that will
serialize to the format shown above.
What should you do? (Each correct answer presents part of the solution. Choose two.)

• A. Insert the following code segment at line PR16 in \Model\Product.cs:
  return new XElement("product, new XAttribute("name", this.Name),
  new XAttribute("description", this.Description),
  new XAttribute("productType", this.ProductType));
• B. Insert the following code segment at line CT14 in \Model\Component.cs:
  return new XElement("component, new XAttribute("name", this.Name),
  new XElement("description", this.Description),
  new XElement("partType", this.PartType));
• C. Insert the following code segment at line CT14 in \Model\Component.cs:
  return new XElement("component, new XAttribute("name", this.Name),
  new XAttribute("description", this.Description),
  new XAttribute("partType", this.PartType));
• D. Insert the following code segment at line CT14 in \Model\Component.cs:
  return new XElement("component, new XElement("name", this.Name),
  new XElement("description", this.Description),
  new XElement("partType", this.PartType));
• E. Insert the following code segment at line PR16 in \Model\Product.cs:
  return new XElement("product, new XElement("name", this.Name),
  new XElement("description", this.Description),
  new XElement("productType", this.ProductType));
• F. Insert the following code segment at line PR16 in \Model\Product.cs:
  return new XElement("product, new XAttribute("name", this.Name),
  new XElement("description", this.Description),
  new XElement("productType", this.ProductType));

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows Forms
application.
You plan to deploy the application to several shared client computers. You write the following code
segment.
(Line numbers are included for reference only.)
01 Configuration config = ConfigurationManager.OpenExeConfiguration
(exeConfigName);
02 ...
03 config.Save();
04 ...
You need to encrypt the connection string stored in the .config file. Which code segment should you insert at line 02?

• A. ConnectionStringsSection section = config.GetSection("connectionString") as ConnectionStringsSection; section.SectionInformation.ProtectSection("DataProtectionConfigurationProvider");
• B. ConnectionStringsSection section = config.GetSection("connectionString") as ConnectionStringsSection; section.SectionInformation.ProtectSection("RsaProtectedConfigurationProvider");
• C. ConnectionStringsSection section = config.GetSection("connectionStrings") as ConnectionStringsSection; section.SectionInformation.ProtectSection("RsaProtectedConfigurationProvider");
• D. ConnectionStringsSection section = config.GetSection("connectionStrings") as ConnectionStringsSection; section.SectionInformation.ProtectSection("DataProtectionConfigurationProvider");

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 model entities. The database includes objects based on the exhibit. (Click the Exhibit
button.)
The application includes the following code segment. (Line numbers are included for reference only.)
01 using (AdventureWorksEntities advWorksContext = new AdventureWorksEntities
()){
02 ...
03 }
You need to retrieve a list of all Products from todays sales orders for a specified customer.
You also need to ensure that the application uses the minimum amount of memory when retrieving the list.
Which code segment should you insert at line 02?

• A. Contact customer = (from contact in context.Contact.Include ("SalesOrderHeader.SalesOrderDetail") select contact).FirstOrDefault(); foreach (SalesOrderHeader order in customer.SalesOrderHeader) {
  if (order.OrderDate.Date == DateTime.Today.Date)
  {
  foreach (SalesOrderDetail item in order.SalesOrderDetail)
  {
  Console.WriteLine(String.Format("Product: {0} ", item.ProductID)); } } }
• B. Contact customer = (from contact in context.Contact.Include ("SalesOrderHeader") select contact).FirstOrDefault(); foreach (SalesOrderHeader order in customer.SalesOrderHeader) {
  order.SalesOrderDetail.Load();
  if (order.OrderDate.Date == DateTime.Today.Date)
  {
  foreach (SalesOrderDetail item in order.SalesOrderDetail)
  {
  Console.WriteLine(String.Format("Product: {0} ", item.ProductID)); } } }
• C. Contact customer = context.Contact.Where("it.ContactID = @customerId", new ObjectParameter("customerId", customerId)).First(); customer.SalesOrderHeader.Load(); foreach (SalesOrderHeader order in customer.SalesOrderHeader) {
  if (order.OrderDate.Date == DateTime.Today.Date)
  {
  order.SalesOrderDetail.Load();
  foreach (SalesOrderDetail item in order.SalesOrderDetail)
  {
  Console.WriteLine(String.Format("Product: {0} ", item.ProductID)); } } }
• D. Contact customer = context.Contact.Where("it.ContactID = @customerId", new ObjectParameter("customerId", customerId)).First(); customer.SalesOrderHeader.Load(); foreach (SalesOrderHeader order in customer.SalesOrderHeader) {
  order.SalesOrderDetail.Load();
  if (order.OrderDate.Date == DateTime.Today.Date)
  {
  foreach (SalesOrderDetail item in order.SalesOrderDetail) { Console.WriteLine(String.Format("Product: {0} ", item.ProductID)); } } }

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 need to use a spatial value type as a parameter for your database query. What should you do?

• A. Set the parameter's SqlDbType to Binary.
• B. Set the parameter's SqlDbType to Udt. Set the parameter's UdtTypeName to GEOMETRY.
• C. Set the parameter's SqlDbType to Structured. Set the parameter's TypeName to GEOMETRY.
• D. Set the parameter's SqlDbType to Variant.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
connects to a Microsoft SQL Server 2008 database.
You use the ADO.NET Entity Framework Designer to model entities. You add the following stored
procedure to the database, and you add a function import to the model.
CREATE PROCEDURE [dbo].[InsertDepartment] @Name nvarchar(50), @ID int NULL OUTPUT
AS INSERT INTO Department (Name) VALUES (@Name) SELECT @ID = SCOPE_IDENTITY()
You need to insert a new department and display the generated ID. Which code segment should you use?

• A. using (SchoolEntities context = new SchoolEntities())
  {
  var id = new ObjectParameter("ID", null));
  context.InsertDepartment("Department 1", id);
  Console.WriteLine(id.Value);
  }
• B. using (SchoolEntities context = new SchoolEntities())
  {
  var id = context.InsertDepartment("Department 1", null);
  Console.WriteLine(id);
  }
• C. using (SchoolEntities context = new SchoolEntities())
  {
  var id = new ObjectParameter("ID", typeof(int));
  context.InsertDepartment("Department 1", id);
  Console.WriteLine(id.Value);
  }
• D. using (SchoolEntities context = new SchoolEntities())
  {
  ObjectParameter id = null;
  context.InsertDepartment("Department 1", id);
  Console.WriteLine(id.Value);
  }