Microsoft TS: Accessing Data with Microsoft .NET Framework 4 : 70-516

Which code segment will properly return the TimeSpan returned by the stopWatch variable?

• A. Stopwatch stopWatch = new Stopwatch();
  stopWatch.Start();
  DoSomething();
  stopWatch.Stop();
  TimeSpan ts = stopWatch.Elapsed;
  string elapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}", ts.Hours, ts.Minutes, ts.Seconds,
  ts.Milliseconds / 10);
  Console.WriteLine(elapsedTime, "RunTime");
  private void DoSomething()
  { ... }
• B. Stopwatch stopWatch = new Stopwatch(); stopWatch.Start(); DoSomething(); TimeSpan ts = stopWatch.Elapsed; string elapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}", ts.Hours, ts.Minutes, ts.Seconds, ts.Milliseconds / 10); Console.WriteLine(elapsedTime, "RunTime");
  private void DoSomething()
  { ... }
• C. Stopwatch stopWatch = new Stopwatch(); stopWatch.Begin(); DoSomething(); stopWatch.End(); TimeSpan ts = stopWatch.Elapsed; string elapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}", ts.Hours, ts.Minutes, ts.Seconds, ts.Milliseconds / 10); Console.WriteLine(elapsedTime, "RunTime");
  private void DoSomething()
  { ... }
• D. Stopwatch stopWatch = new Stopwatch(); stopWatch.Start(); DoSomething(); stopWatch.Reset(); TimeSpan ts = stopWatch.Elapsed; string elapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}", ts.Hours, ts.Minutes, ts.Seconds, ts.Milliseconds / 10); Console.WriteLine(elapsedTime, "RunTime");
  private void DoSomething()
  { ... }

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 use the ADO.NET Entity Framework to model your entities. You use ADO.NET self-tracking entities.
You need to ensure that the change-tracking information for the self-tracking entities can be used to update
the database.
Which ObjectContext method should you call after changes are made to the entities?

• A. ApplyChanges
• B. SaveChanges
• C. Attach
• D. Refresh

You use Microsoft .NET Framework 4.0 to develop an ASP.NET Web application that connects to a
Microsoft SQL Server 2008 database.
The application uses Integrated Windows authentication in Internet Information Services (IIS) to
authenticate users.
A connection string named connString defines a connection to the database by using integrated security.
You need to ensure that a SqlCommand executes under the application pool's identity on the database
server.
Which code segment should you use?

• A. using (var conn = new SqlConnection(connString))
  {
  var cmd = new SqlCommand ("SELECT * FROM BLOG, conn);
  conn.Open();
  using(HostingEnvironment.Impersonate())
  {
  var result = cmd.ExecuteScalar();
  }
  }
• B. using (var conn = new SqlConnection())
  {
  conn.ConnectionString = connString;
  SqlCommand cmd = null;
  using (HostingEnvironment.Impersonate())
  {
  cmd = new SqlCommand("SELECT * FROM BLOG", conn);
  }
  conn.Open();
  var result = cmd.ExecuteScalar();
  }
• C. using (var conn = new SqlConneccion())
  {
  using (HostingEnvironroent.Impersonate())
  {
  conn.ConnectionString = connString;
  }
  var cmd = new SqlCommand("SELECT * FROM BLOG, conn);
  conn.Open() ;
  var result = cmd.ExecuteScalar();
  }
• D. using (var conn = new SqlConnection())
  {
  conn.ConnectionString = connString;
  var cmd = new SqlCommand("SELECT * FROM BLOG", conn);
  using (HostingEnvironment.Impersonate())
  {
  conn.Open();
  }
  var result = cmd.ExecuteScalar();
  }

You are developing a new feature in the application to display a list of all bundled products.
You need to write a LINQ query that will return a list of all bundled products. Which query expression should
you use?

• A. context.Parts.OfType<Product>() .Where(p => p.Descendants.Any(d => d is Product))
• B. context.Parts.Cast<Product>() .Where(p => p.Descendants.Any(d => d is Product))
• C. context.Parts.OfType<Product>() .ToList() .Where(p => p.Descendants.Any(d => d is Product))
• D. context.Parts.Cast<Product>() .ToList() .Where(p => p.Descendants.Any(d => d is Product))

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.RequiresNew)
  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.Suppress)
  Insert the following code segment at line 08.
  using (SqlConnection cn2 = new SqlConnection(sql2))
  {
  try
  {
  cn2.Open();
  ...
  cn1.Open();
  ...
  }
  catch (Exception ex){}
  }
• D. 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){}
  }