Online Access Free 70-516 Exam Questions

You use Microsoft .NET Framework 4 to develop an application that connects to a Microsoft SQL Server
2008 database.
The database contains a ClassStudent table that contains the StudentID for students who are enrolled in
the classes.
You add the following stored procedure to the database.
CREATE PROCEDURE [dbo].[GetNumEnrolled] @ClassID INT, @NumEnrolled INT OUTPUT
AS BEGIN SET NOCOUNT ON SELECT @NumEnrolled = COUNT(StudentID)
FROM ClassStudent
WHERE (ClassID = @ClassID)
END
You write the following code. (Line numbers are included for reference only.)
01 private int GetNumberEnrolled(string classID)
02 {
03 using (SqlConnection conn = new SqlConnection(GetConnectionString())
04 {
05 SqlCommand cmd = new SqlCommand("GetNumEnrolled", conn);
06 cmd.CommandType = CommandType.StoredProcedure;
07 SqlParameter parClass = cmd.Parameters.Add("@ClassID", SqlDbType.Int,
4, "classID");
08 SqlParameter parNum = cmd.Parameters.Add("@NumEnrolled",
SqlDbType.Int);
09 ...
10 conn.Open()
11 ...
12 }
13 }
You need to ensure that the GetNumberEnrolled method returns the number of students who are enrolled
for a specific class.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A.Insert the following code at line 11.
  cmd.ExecuteNonQuery();
  return (int)parNum.Value;
• B.Insert the following code at line 11.
  int numEnrolled = 0;
  SqlDataReader reader = cmd.ExecuteReader();
  while(reader.Read())
  {
  numEnrolled = numEnrolled + (int)cmd.Parameters["@NumEnrolled"].Value; } return numEnrolled;
• C.Insert the following code at line 09.
  parNum.Direction = ParameterDirection.Input;
• D.Insert the following code at line 09.
  parNum.Direction = ParameterDirection.Output;

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application contains the following XML fragment:
<ApplicationMenu> <MenuItem name="File">
<MenuItem name="New">
<MenuItem name="Project" />
<MenuItem name="Web Site" />
</MenuItem>
<MenuItem name="Open">
<MenuItem name="Project" />
<MenuItem name="Web Site" />
</MenuItem>
<MenuItem name="Save" />
</MenuItem>
<MenuItem name="Edit">
<MenuItem name="Cut" />
<MenuItem name="Copy" />
<MenuItem name="Paste" />
</MenuItem>
<MenuItem name="Help">
<MenuItem name="Help" />
<MenuItem name="About" />
</MenuItem> </ApplicationMenu>
The application queries the XML fragment by using the XmlDocument class. You need to select all the descendant elements of the MenuItem element that has its name attribute as File. Which XPath expression should you use?

• A./ApplicationMenu/MenuItem/descendant::MenuItem['File']
• B./ApplicationMenu/MenuItem['File']//MenuItem
• C.//*[@name='File'][name()='MenuItem']
• D./ApplicationMenu/MenuItem[@name='File']/descendant::MenuItem

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
uses LINQ to SQL.
You create a data model name AdvWorksDataContext, and you add the Product table to the data model.
The Product table contains a decimal column named ListPrice and a string column named Color.
You need to update ListPrice column where the product color is Black or Red. Which code segment should
you use?

• A.AdvWorksDataContext dc = new AdvWorksDataContext("..."); var prod = from p in dc.Products
  select p;
  var list = prod.ToList();
  foreach(Product product in list){
  if((product.Color == "Black) && (product.Color == "Red")){
  product.ListPrice = product.StandardCost * 1.5M;
  }
  }
  dc.SubmitChanges();
• B.AdvWorksDataContext dc = new AdvWorksDataContext("..."); var prod = from p in dc.Products
  select p;
  var list = prod.ToList();
  foreach(Product product in list){
  if(product.Color == "Black, Red"){
  product.ListPrice = product.StandardCost * 1.5M;
  }
  }
  dc.SubmitChanges();
• C.AdvWorksDataContext dc = new AdvWorksDataContext("...");
  var prod = from p in dc.Products
  where p.Color == "Black, Red"
  select p;
  foreach(var product in prod){
  product.ListPrice = product.StandardCost * 1.5M;
  }
  dc.SubmitChanges();
• D.string[] colorList = new string[] {"Black", "Red"}; AdvWorksDataContext dc = new AdvWorksDataContext(); var prod = from p in dc.Products
  where colorList.Contains(p.Color)
  select p;
  foreach(var product in prod){
  product.ListPrice = product.StandardCost * 1.5M;
  }
  dc.SubmitChanges();

You are developing a WCF data service that will expose an existing Entity Data Model (EDM). You have the following requirements:
-Users must be able to read all entities that are exposed in the EDM.
-Users must be able to update or replace the SalesOrderHeader entities.
-Users must be prevented from inserting or deleting the SalesOrderHeader entities
You need to ensure that the data service meets the requirements. Which code segment should you use in the Initialize method?

• A.config.SetEntitySetAccessRule("*", EntitySetRights.AllRead); config.SetEntitySetAccessRule("SalesOrderHeader", EntitySetRights.WriteAppend |
  EntitySetRights.WriteDelete);
• B.config.SetEntitySetAccessRule("*", EntitySetRights.AllRead); config.SetEntitySetAccessRule("SalesOrderHeader", EntitySetRights.WriteMerge | EntitySetRights.WriteReplace);
• C.config.SetEntitySetAccessRule("*", EntitySetRights.AllRead); config.SetEntitySetAccessRule("SalesOrderHeader", EntitySetRights.AllWrite);
• D.config.SetEntitySetAccessRule("*", EntitySetRights.AllRead); config.SetEntitySetAccessRule("SalesOrderHeader", EntitySetRights.All);

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
uses the EntityFramework.
The application has an entity named Person. A Person instance named person1 and an ObjectContext
instance named model exist.
You need to delete the person1 instance. Which code segment should you use?

• A.model.Detach(person1); model.SaveChanges();
• B.model.ExecuteStoreCommand("Delete", new []{new ObjectParameter("Person", person1)}; model.SaveChanges();
• C.model.ExecuteStoreCommand("Detach", new []{new ObjectParameter("Person", person1)}; model.SaveChanges();
• D.model.DeleteObject(person1); model.SaveChanges();