Try and practice the latest Microsoft : 070-516 real questions & answers

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 uses DataContexts to query
the database.
The application meets the following requirements:
-Stores customer data offline.
-Allows users to update customer records while they are disconnected from the server.
-Enables offline changes to be submitted back to the SQL Server by using the DataContext object.
You need to ensure that the application can detect all conflicts that occur between the offline customer information submitted to the SQL Server and the server version. You also need to ensure that you can roll back local changes. What should you do?

• A. Add a try/catch statement around calls to the SubmitChanges method of the DataContext object and catch ChangeConflictExceptions.
• B. Override the Update operation of the DataContext object. Call the ExecuteDynamicUpdate method to generate the update SQL.
• C. Add a try/catch statement around calls to the SubmitChanges method of the DataContext object and catch SqlExceptions.
• D. Call the SubmitChanges method of the DataContext object. Pass System.Data.Linq.ConflictMode.ContinueOnConflict to the method.

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

You use Microsoft .NET Framework 4.0 to develop an application that uses the Entity Framework.
The application defines the following Entity SQL (ESQL) query, which must be executed against the mode.
string prodQuery = "select value p from Products as p where
p.ProductCategory.Name = @p0";
You need to execute the query. Which code segment should you use?

• A. var prods = ctx.ExecuteFunction<Product>(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();
• B. var prods = ctx.ExecuteStoreCommand(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();
• C. var prods = ctx.ExecuteStoreQuery<Product>(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();
• D. var prods = ctx.CreateQuery<Product>(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();

You use Microsoft .NET Framework 4.0 to develop an application. You use the XmlReader class to load
XML from a location that you do not control.
You need to ensure that loading the XML will not load external resources that are referenced in the XML.
Which code segment should you use?

• A. XmlReaderSettings settings = new XmlReaderSettings(); settings.CheckCharacters = true; XmlReader reader = XmlReader.Create("data.xml", settings);
• B. XmlReaderSettings settings = new XmlReaderSettings(); settings.ValidationType = ValidationType.None; XmlReader reader = XmlReader.Create("data.xml", settings);
• C. XmlReaderSettings settings = new XmlReaderSettings(); settings.ConformanceLevel = ConformanceLevel.Auto; XmlReader reader = XmlReader.Create("data.xml", settings);
• D. XmlReaderSettings settings = new XmlReaderSettings(); settings.XmlResolver = null; XmlReader reader = XmlReader.Create("data.xml", settings);

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Windows Forms
application.
The application connects to a Microsoft SQL Server database.
You need to find out whether the application is explicitly closing or disposing SQL connections. Which code
segment should you use?

• A. string instanceName = Assembly.GetEntryAssembly().GetName().Name; PerformanceCounter perf = new PerformanceCounter( ".NET Data Provider for SqlServer",
  "NumberOfReclaimedConnections", instanceName, true); int leakedConnections = (int)perf.NextValue();
• B. string instanceName = Assembly.GetEntryAssembly().GetName().Name; PerformanceCounter perf = new PerformanceCounter( ".NET Data Provider for SqlServer",
  "NumberOfNonPooledConnections", instanceName, true); int leakedConnections = (int)perf.NextValue();
• C. string instanceName = Assembly.GetEntryAssembly().FullName; PerformanceCounter perf = new PerformanceCounter( ".NET Data Provider for SqlServer",
  "NumberOfReclaimedConnections", instanceName, true); int leakedConnections = (int)perf.NextValue();
• D. string instanceName = Assembly.GetEntryAssembly().FullName; PerformanceCounter perf = new PerformanceCounter( ".NET Data Provider for SqlServer",
  "NumberOfNonPooledConnections", instanceName, true); int leakedConnections = (int)perf.NextValue();