You use Microsoft .NET Framework 4.0 to develop an ASP.NET Web application that connects to a
Microsoft SQL Server 2008 database.
The application uses Integrated Windows authentication in Internet Information Services (IIS) to
authenticate users.
A connection string named connString defines a connection to the database by using integrated security.
You need to ensure that a SqlCommand executes under the application pool's identity on the database
server.
Which code segment should you use?

• A. using (var conn = new SqlConnection(connString))
  {
  var cmd = new SqlCommand ("SELECT * FROM BLOG, conn);
  conn.Open();
  using(HostingEnvironment.Impersonate())
  {
  var result = cmd.ExecuteScalar();
  }
  }
• B. using (var conn = new SqlConnection())
  {
  conn.ConnectionString = connString;
  var cmd = new SqlCommand("SELECT * FROM BLOG", conn);
  using (HostingEnvironment.Impersonate())
  {
  conn.Open();
  }
  var result = cmd.ExecuteScalar();
  }
• C. using (var conn = new SqlConnection())
  {
  conn.ConnectionString = connString;
  SqlCommand cmd = null;
  using (HostingEnvironment.Impersonate())
  {
  cmd = new SqlCommand("SELECT * FROM BLOG", conn);
  }
  conn.Open();
  var result = cmd.ExecuteScalar();
  }
• D. using (var conn = new SqlConneccion())
  {
  using (HostingEnvironroent.Impersonate())
  {
  conn.ConnectionString = connString;
  }
  var cmd = new SqlCommand("SELECT * FROM BLOG, conn);
  conn.Open() ;
  var result = cmd.ExecuteScalar();
  }

You need to write a LINQ query that can be used against a ContosoEntities context object named context to
find all
parts that have a duplicate name. Which of the following queries should you use?
(Each correct answer presents a complete solution. Choose two).

• A. context.Parts.Any(p => context.Parts.Any(q => p.Name == q.Name));
• B. context.Parts.GroupBy(p => p.Name).Where(g => g.Count() > 1).SelectMany(x => x);
• C. context.Parts.Where(p => context.Parts.Any(q => q.Name == p.Name && p.Id != q.Id);
• D. context.Parts.SelectMany(p => context.Parts.Select(q => p.Name == q.Name && p.Id != q.Id));

You use Microsoft .NET Framework 4.0 to develop an application that uses the Entity Framework.
The application defines the following Entity SQL (ESQL) query, which must be executed against the mode.
string prodQuery = "select value p from Products as p where
p.ProductCategory.Name = @p0";
You need to execute the query. Which code segment should you use?

• A. var prods = ctx.ExecuteStoreCommand(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();
• B. var prods = ctx.CreateQuery<Product>(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();
• C. var prods = ctx.ExecuteStoreQuery<Product>(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();
• D. var prods = ctx.ExecuteFunction<Product>(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();

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 XElement("name", this.Name),
  new XElement("description", this.Description),
  new XElement("productType", this.ProductType));
• B. 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));
• C. 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));
• D. 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));
• E. 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));
• F. 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));

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. You retrieve an entity from an object context.
A different application updates the database. You need to update the entity instance to reflect updated
values in the database.
Which line of code should you use?

• A. context.LoadProperty(entity, "Client", MergeOption.OverwriteChanges);
• B. context.LoadProperty(entity, "Server", MergeOption.OverwriteChanges);
• C. context.Refresh(RefreshMode.StoreWins, entity);
• D. context.AcceptAllChanges();