You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to two different Microsoft SQL Server 2008 database servers named Server1 and
Server2.
A string named sql1 contains a connection string to Server1. A string named sql2 contains a connection
string to Server2.
01 using (TransactionScope scope = new
02 ...
03 )
04 {
05 using (SqlConnection cn1 = new SqlConnection(sql1))
06 {
07 try{
08 ...
09 }
10 catch (Exception ex)
11 {
12 }
13 }
14 scope.Complete();
15 }
You need to ensure that the application meets the following requirements:
-There is a SqlConnection named cn2 that uses sql2.
-The commands that use cn1 are initially enlisted as a lightweight transaction.
The cn2 SqlConnection is enlisted in the same TransactionScope only if commands executed by cn1 do not
throw an exception.
What should you do?

• A. Insert the following code segment at line 02.
  TransactionScope(TransactionScopeOption.Suppress)
  Insert the following code segment at line 08.
  cn1.Open();
  ...
  using (SqlConnection cn2 = new SqlConnection(sql2))
  {
  try
  {
  cn2.Open();
  ...
  }
  catch (Exception ex){}
  }
• B. Insert the following code segment at line 02.
  TransactionScope(TransactionScopeOption.Suppress)
  Insert the following code segment at line 08.
  using (SqlConnection cn2 = new SqlConnection(sql2))
  {
  try
  {
  cn2.Open();
  ...
  cn1.Open();
  ...
  }
  catch (Exception ex){}
  }
• C. Insert the following code segment at line 02.
  TransactionScope(TransactionScopeOption.RequiresNew)
  Insert the following code segment at line 08.
  cn1.Open();
  ...
  using (SqlConnection cn2 = new SqlConnection(sql2))
  {
  try
  {
  cn2.Open();
  ...
  }
  catch (Exception ex){}
  }
• D. Insert the following code segment at line 02.
  TransactionScope(TransactionScopeOption.RequiresNew)
  Insert the following code segment at line 08.
  using (SqlConnection cn2 = new SqlConnection(sql2)) {
  try{
  cn2.Open();
  ...
  cn1.Open();
  ...
  }
  catch (Exception ex){}
  }

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
The application connects to a Microsoft SQL Server 2008 database. You must retrieve a connection string.
Which of the following is the correct connection string?

• A. string connectionString = ConfigurationManager.ConnectionStrings ["connectionString"].ConnectionString;
• B. string connectionString = ConfigurationManager.AppSettings["connectionString"];
• C. string connectionString = ApplicationManager.ConnectionStrings["connectionString"];
• D. string connectionString = ConfigurationSettings.AppSettings["connectionString"];

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application.
You use the ADO.NET Entity Framework to model your entities.
You use Plain Old CLR Objects (POCO) entities along with snapshot-based change tracking. The code
accesses the POCO entities directly.
You need to ensure that the state manager synchronizes when changes are made to the object graph.
Which ObjectContext method should you call?

• A. DetectChanges
• B. Refresh
• C. SaveChanges
• D. ApplyPropertyChanges

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 model entities.
You need to create a database from your model. What should you do?

• A. Run the edmgen.exe tool in FromSSDLGeneration mode.
• B. Run the edmgen.exe tool in FullGeneration mode.
• C. Use the Update Model Wizard in Visual Studio.
• D. Use the Generate Database Wizard in Visual Studio. Run the resulting script against a Microsoft SQL Server database.

A performance issue exists in the application. The following code segment is causing a performance bottleneck:
var colors = context.Parts.GetColors();
You need to improve application performance by reducing the number of database calls. Which code segment should you use?

• A. var colors = context.Parts.OfType<Product>().Include ("Parts.Color").GetColors();
• B. var colors = context.Parts.OfType<Product>().Include("Color").GetColors();
• C. var colors = context.Parts.OfType<Product>().Include ("Product.Color").GetColors();
• D. var colors = context.Parts.OfType<Product>().Include("Colors").GetColors();