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

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. 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();
  }
• C. Insert the following code segment at line 04.
  private SqlConnection conn = new SqlConnection(connString);
  public void Open()
  {
  conn.Open();
  }
  public void Close()
  {
  conn.Close();
  }
• D. Insert the following code segment at line 07:
  using (SqlConnection conn = new SqlConnection(connString))
  {
  conn.Open();
  }

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows
Communication
Foundation (WCF) Data Services service. You deploy the data service to the following URL: http://
contoso.com/Northwind.svc.
You add the following code segment. (Line numbers are included for reference only.)
01 var uri = new Uri(@"http://contoso.com/Northwind.svc/");
02 var ctx = new NorthwindEntities(uri);
03 var categories = from c in ctx.Categories select c;
04 foreach (var category in categories) {
05 PrintCategory(category);
06 ...
07 foreach (var product in category.Products) {
08 ...
09 PrintProduct(product);
10 }
11 }
You need to ensure that the Product data for each Category object is lazy-loaded. What should you do?

• A. Add the following code segment at line 06:
  ctx.LoadProperty(category, "Products");
• B. Add the following code segment at line 08:
  var strprdUri= string.format("Products?$filter=CategoryID eq {0}",
  category.CategoryID);
  var prodcutUri = new Uri(strPrd, UriKind.Relative);
  ctx.Execute<Product>(productUri);
• C. Add the following code segment at line 08:
  ctx.LoadProperty(product, "*");
• D. Add the following code segment at line 06:
  var strPrdUri = string.Format("Categories({0})?$expand=Products",
  category.CategoryID);
  var productUri = new Uri(strPrdUri, UriKind.Relative);
  ctx.Execute<Product>(productUri);

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 stores encrypted credit card
numbers in the database.
You need to ensure that credit card numbers can be extracted from the database.
Which cryptography provider should you use?

• A. AESCryptoServiceProvider
• B. DSACryptoServiceProvider
• C. SHA1CryptoServiceProvider
• D. MD5CryptoServiceProvider