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.
The database includes a database table named ProductCatalog as shown in the exhibit:

You add the following code segment to query the first row of the ProductCatalog table. (Line numbers are included for reference only.)
01 using(SqlConnection cnx = new SqlConnection(connString)
02 {
03 var command = cnx.CreateCommand();
04 command.CommandType = CommandType.Text;
05 command.CommandText = "SELECT TOP 1 * FROM dbo.ProductCatalog";
06 cnx.Open();
07 var reader = command.ExecuteReader();
08 if (reader.Read())
09 {
10 var id = reader.GetInt32(0);
11 ...
12 reader.Close();
13 }
14 }
Which answer belongs in line 11?

• A. var weight = reader.GetFloat(1); var price = reader.Doublel(2); var status = reader.GetByte(3);
• B. var weight = reader.GetDouble(1); var price = reader.GetFloat(2); var status = reader.GetBoolean(3);
• C. var weight
  = reader.GetFloat(1); var price = reader.GetDecimal(2); var status = reader.GetByte(3);
• D. var weight = reader.GetDouble(1); var price = reader.GetDecimal(2); var status = reader.GetBoolean(3);

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 ensure that the model and mapping files are not deployed as application resources. What
should you do?

• A. Modify the connection string in the application's .config file to refer to the absolute physical path to the .edmx file.
• B. Set the value of the .edmx file's Metadata Artifact Processing property to Copy to Output Directory.
• C. Set the value of the .edmx file's Build Action property to Copy to Output.
• D. Modify the connection string in the application's .config file to refer to the relative path to the .edmx file.

You use Microsoft .NET Framework 4.0 and the Entity Framework to develop an application.
You create an Entity Data Model that has an entity named Customer. You set the optimistic concurrency
option for Customer.
You load and modify an instance of Customer named loadedCustomer, which is attached to an
ObjectContext named context.
You need to ensure that if a concurrency conflict occurs during a save, the application will load up-to-date
values from
the database while preserving local changes. Which code segment should you use?

• A. try {
  context.SaveChanges();
  }
  catch(EntitySqlException ex)
  {
  context.Refresh(RefreshMode.ClientWins, loadedCustomer);
  }
• B. try {
  context.SaveChanges();
  }
  catch(OptimisticConcurrencyException ex)
  {
  context.Refresh(RefreshMode.ClientWins, loadedCustomer);
  }
• C. try {
  context.SaveChanges();
  }
  catch(EntitySqlException ex)
  {
  context.Refresh(RefreshMode.StoreWins, loadedCustomer);
  }
• D. try {
  context.SaveChanges();
  }
  catch(OptimisticConcurrencyException ex)
  {
  context.Refresh(RefreshMode.StoreWins, loadedCustomer);
  }

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. The application contains two
SqlCommand objects named cmd1 and cmd2.
You need to measure the time required to execute each command. Which code segment should you use?

• A. Stopwatch w1 = Stopwatch.StartNew(); cmd1.ExecuteNonQuery(); w1.Stop(); Trace.WriteLine(w1.ElapsedMilliseconds); w1.Start(); cmd2.ExecuteNonQuery(); w1.Stop(); Trace.WriteLine(w1.ElapsedMilliseconds);
• B. Stopwatch w1 = Stopwatch.StartNew(); cmd1.ExecuteNonQuery(); w1.Stop(); Trace.WriteLine(w1.ElapsedMilliseconds); w1 = Stopwatch.StartNew(); cmd2.ExecuteNonQuery(); w1.Stop(); Trace.WriteLine(w1.ElapsedMilliseconds);
• C. Stopwatch w1 = new Stopwatch(); w1.Start(); cmd1.ExecuteNonQuery(); w1.Stop(); Trace.WriteLine(w1.ElapsedMilliseconds); w1.Start(); cmd2.ExecuteNonQuery(); w1.Stop(); Trace.WriteLine(w1.ElapsedMilliseconds);
• D. Stopwatch w1 = new Stopwatch(); w1.Start(); cmd1.ExecuteNonQuery(); w1.Stop(); Trace.WriteLine(w1.ElapsedMilliseconds); w1.Reset(); cmd2.ExecuteNonQuery(); w1.Stop(); Trace.WriteLine(w1.ElapsedMilliseconds);