Online Access Free 070-516 Practice Test

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("save2");
• B.tran.Rollback("save2"); tran.Commit();
• C.tran.Rollback(); tran.Commit();
• D.tran.Rollback();

The database contains orphaned Color records that are no longer connected to Part records.
You need to clean up the orphaned records. You have an existing ContosoEntities context object named
context.
Which code segment should you use?

• A.context.Colors.ToList().RemoveAll(c => !c.Parts.Any()); context.SaveChanges();
• B.var unusedColors = context.Colors.Where(c => !c.Parts.Any()).ToList(); foreach (var unused in unusedColors){
  context.DeleteObject(unused)
  }
  context.SaveChanges();
• C.var unusedColors = context.Colors.Where(c => !c.Parts.Any()); context.DeleteObject(unusedColors); context.SaveChanges();
• D.context.Colors.TakeWhile(c => !c.Parts.Any()); context.SaveChanges();

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 need to retrieve an entity, and you must ensure that the entity is loaded in a detached state.
Which MergeOption enumeration value should you use to retrieve the entity?

• A.NoTracking
• B.OverwriteChanges
• C.PreserveChanges
• D.AppendOnly

You are a tasked with performing a code review. The business rule is the following:
-If INSERTs into the first table succeed, then INSERT into the second table.
-However, if the INSERTs into the second table fail, roll back the inserts in the second table but do not roll back the inserts in the first table.
-Although this can also be done by way of regular transactions, It needs to be performed using
TransactionScope objects.
Whis code would fit this business rule?

• A.try
  {
  using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption)
  {
  ....
  try
  {
  .....
  using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption))
  { .... }
  }
  }
  }
• B.try
  { using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) {
  ...
  using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption.RequiresNew))
  { .... }
  ......
  }
  }
• C.try
  { using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) {
  ....
  try
  {
  .....
  using (TransactionScope scope2 = new TransactionScope
  (TransactionScopeOption.RequiresNew))
  { .... }
  }
  }
  }
• D.try
  { using (TransactionScope scope1 = new TransactionScope(TransactionScopeOption.Required)) {
  ...
  }
  using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption.RequiresNew)) { .... } }

The application must be configured to run on a new development computer.
You need to configure the connection string to point to the existing named instance.
Which connection string fragment should you use?

• A.Data Source=INST01\SQL01
• B.Initial Catalog= INST01\SQL01
• C.Initial Catalog= SQL01\INST01
• D.Data Source=SQL01\INST01