Microsoft 70-516 Value Pack (Frequently Bought Together)

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. The application includes a SqlConnection named
conn and a SqlCommand named cmd.
You need to create a transaction so that database changes will be reverted in the event that an exception is
thrown.
Which code segment should you use?

• A. var transaction = conn.BeginTransaction(); cmd.Transaction = transaction; try {
  ...
  transaction.Commit();
  }
  catch
  {
  transaction.Rollback();
  }
• B. var transaction = conn.BeginTransaction(); cmd.Transaction = transaction; try {
  ...
  transaction.Commit();
  }
  catch
  {
  transaction.Dispose();
  }
• C. var transaction = conn.BeginTransaction(); cmd.Transaction = transaction; try {
  ...
  transaction.Rollback();
  }
  catch
  {
  transaction.Dispose();
  }
• D. var transaction = conn.BeginTransaction(); cmd.Transaction = transaction; try {
  ...
  }
  catch
  {
  transaction.Commit();
  }

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.
The application includes the following code segment. (Line numbers are included for reference only.)
01 using (AdventureWorksEntities context = new AdventureWorksEntities()){
02 ...
03 foreach (SalesOrderHeader order in customer.SalesOrderHeader){
04 Console.WriteLine(String.Format("Order: {0} ",
order.SalesOrderNumber));
05 foreach (SalesOrderDetail item in order.SalesOrderDetail){
06 Console.WriteLine(String.Format("Quantity: {0} ", item.Quantity));
07 Console.WriteLine(String.Format("Product: {0} ",
item.Product.Name));
08 }
09 }
10 }
You want to list all the orders for a specified customer. You need to ensure that the list contains the following fields:
-Order number
-Quantity of products
-Product name
Which code segment should you insert at line 02?

• A. Contact customer = (from contact in context.Contact
  include("SalesOrderHeader") select conatct).FirstOrDefault();
• B. Contact customer = context.Contact.Where("it.ContactID = @customerId", new ObjectParameter ("customerId", customerId)).First();
• C. context.ContextOptions.LazyLoadingEnabled = true;
  Contact customer = (from contact in context.Contact
  include("SalesOrderHeader.SalesOrderDetail")
  select conatct).FirstOrDefault();
• D. Contact customer = context.Contact.Where("it.ContactID = @customerId", new ObjectParameter ("@customerId", customerId)).First();

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application contains the following code segment. (Line numbers are included for reference only.)
01 class DataAccessLayer
02 {
03 private static string connString;
04 ...
05 ...
06 public static DataTable GetDataTable(string command){
07 ...
08 ...
09 }
10 }
You need to define the connection life cycle of the DataAccessLayer class.
You also need to ensure that the application uses the minimum number of connections to the database.
What should you do?

• A. Insert the following code segment at line 04.
  private static SqlConnection conn = new SqlConnection(connString);
  public static void Open()
  {
  conn.Open();
  }
  public static void Close()
  {
  conn.Close();
  }
• B. Insert the following code segment at line 07:
  using (SqlConnection conn = new SqlConnection(connString))
  {
  conn.Open();
  }
• C. Replace line 01 with the following code segment.
  class DataAccessLayer : IDisposable
  Insert the following code segment to line 04.
  private SqlConnection conn = new SqlConnection(connString);
  public void Open()
  {
  conn.Open();
  }
  public void Dispose()
  {
  conn.Close();
  }
• D. Insert the following code segment at line 04.
  private SqlConnection conn = new SqlConnection(connString);
  public void Open()
  {
  conn.Open();
  }
  public void Close()
  {
  conn.Close();
  }

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 09.
  parNum.Direction = ParameterDirection.Input;
• B. Insert the following code at line 11.
  cmd.ExecuteNonQuery();
  return (int)parNum.Value;
• C. 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;
• 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 uses the ADO.NET Entity Framework to manage Plain Old CLR Objects (POCO) entities.
You create a new POCO class. You need to ensure that the class meets the following requirements:
-It can be used by an ObjectContext.
-It is enabled for change-tracking proxies.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A. Modify each mapped property to contain sealed and protected accessors.
• B. Configure the navigation property to return a type that implements the IQueryable interface.
• C. Configure the navigation property to return a type that implements the IEntityWithRelationships interface.
• D. Configure the navigation property to return a type that implements the ICollection interface.
• E. Modify each mapped property to contain non-sealed, public, and virtual accessors.