Microsoft 070-516 Value Pack (Frequently Bought Together)

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to several SQL Server databases. You create a function that modifies customer
records that are stored in multiple databases.
All updates for a given record are performed in a single transaction. You need to ensure that all transactions
can be recovered. What should you do?

• A. Call the EnlistDurable method of the Transaction class.
• B. Call the EnlistVolatile method of the Transaction class.
• C. Call the RecoveryComplete method of the TransactionManager class.
• D. Call the Reenlist method of the TransactionManager class.

You have been assigned the task of writing code that executes an Entity SQL query that returns entity type
objects that contain a property of a complex type.
(Line numbers are included for reference only.)
01 using (EntityCommand cmd = conn.CreateCommand())
02 {
03 cmd.CommandText = esqlQuery;
04 EntityParameter param = new EntityParameter();
05 param.ParameterName = "id";
06 param.Value = 3;
07 cmd.Parameters.Add(param);
08 using (EntityDataReader rdr = cmd.ExecuteReader
(CommandBehavior.SequentialAccess))
09 {
10 while (rdr.Read())
11 {
12 ...
13 Console.WriteLine("Email and Phone Info:");
14 for (int i = 0; i < nestedRecord.FieldCount; i++)
15 {
16 Console.WriteLine(" " + nestedRecord.GetName(i) + ": " +
nestedRecord.GetValue(i));
17 }
18 }
19 }
20 }
Which code segment should you insert at line 12?

• A. DbDataRecord nestedRecord = rdr["EmailPhoneComplexProperty"] as DbDataRecord;
• B. ComplexDataRecord nestedRecord = rdr["EmailPhoneComplexProperty"]
• C. DbDataRecord nestedRecord = rdr["EmailPhoneComplexProperty"]
• D. DataSet nestedRecord = rdr["EmailPhoneComplexProperty"] as ComplexDataSet

You use Microsoft .NET Framework 4.0 to develop an application that connects to two separate Microsoft
SQL Server 2008 databases.
The Customers database stores all the customer information, and the Orders database stores all the order
information.
The application includes the following code. (Line numbers are included for reference only.)
01 try
02 {
03 conn.Open();
04 tran = conn.BeginTransaction("Order");
05 SqlCommand cmd = new SqlCommand();
06 cmd.Connection = conn;
07 cmd.Transaction = tran;
08 tran.Save("save1");
09 cmd.CommandText = "INSERT INTO [Cust].dbo.Customer " + "(Name,
PhoneNumber) VALUES ('Paul Jones', " + "'404-555-1212')";
10 cmd.ExecuteNonQuery();
11 tran.Save("save2");
12 cmd.CommandText = "INSERT INTO [Orders].dbo.Order " + "(CustomerID)
VALUES (1234)";
13 cmd.ExecuteNonQuery();
14 tran.Save("save3");
15 cmd.CommandText = "INSERT INTO [Orders].dbo." + "OrderDetail (OrderlD,
ProductNumber) VALUES" + "(5678, 'DC-6721')";
16 cmd.ExecuteNonQuery();
17 tran.Commit();
18 }
19 catch (Exception ex)
20 {
21 ...
22 }
You run the program, and a timeout expired error occurs at line 16. You need to ensure that the customer
information is saved in the database.
If an error occurs while the order is being saved, you must roll back all of the order information and save the
customer information.
Which line of code should you insert at line 21?

• A. tran.Rollback();
• B. tran.Rollback(); tran.Commit();
• C. tran.Rollback("save2");
• D. tran.Rollback("save2"); tran.Commit();

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You create a Database Access Layer (DAL) that is database-independent. The DAL includes the following
code segment.
(Line numbers are included for reference only.)
01 static void ExecuteDbCommand(DbConnection connection)
02 {
03 if (connection != null){
04 using (connection){
05 try{
06 connection.Open();
07 DbCommand command = connection.CreateCommand();
08 command.CommandText = "INSERT INTO Categories (CategoryName)
VALUES ('Low Carb')";
09 command.ExecuteNonQuery();
10 }
11 ...
12 catch (Exception ex){
13 Trace.WriteLine("Exception.Message: " + ex.Message);
14 }
15 }
16 }
17 }
You need to log information about any error that occurs during data access.
You also need to log the data provider that accesses the database. Which code segment should you insert
at line 11?

• A. catch (DbException ex){ Trace.WriteLine("ExceptionType: " + ex.Source);
  Trace.WriteLine("Message: " + ex.Message);
  }
• B. catch (DbException ex){ Trace.WriteLine("ExceptionType: " + ex.InnerException.Source);
  Trace.WriteLine("Message: " + ex.InnerException.Message);
  }
• C. catch (OleDbException ex){ Trace.WriteLine("ExceptionType: " + ex.Source);
  Trace.WriteLine("Message: " + ex.Message);
  }
• D. catch (OleDbException ex){ Trace.WriteLine("ExceptionType: " + ex.InnerException.Source);
  Trace.WriteLine("Message: " + ex.InnerException.Message);
  }

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You use the ADO.NET Entity Data Model (EDM) to define a Customer entity.
You need to add a new Customer to the data store without setting all the customer's properties. What
should you do?

• A. Override the SaveChanges method for the Customer object.
• B. Call the CreateObject method of the Customer object.
• C. Override the Create method for the Customer object.
• D. Call the Create method of the Customer object.