Microsoft UPG:Transition MCPD.NET Frmwrk 3.5 Web Dev to 4 Web Dev Sample Questions:

1. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The
application connects to a Microsoft SQL Server database. You write the following code segment that
executes two commands against the database within a transaction. (Line numbers are included for
reference only.)
01using (SqlConnection connection = new SqlConnection(cnnStr)) {
02connection.Open();
03SqlTransaction sqlTran = connection.BeginTransaction();
04SqlCommand command = connection.CreateCommand();
05command.Transaction = sqlTran;
06try {
07command.CommandText = "INSERT INTO Production.ScrapReason(Name) VALUES('Wrong size')";
08command.ExecuteNonQuery();
09command.CommandText = "INSERT INTO Production.ScrapReason(Name) VALUES('Wrong color')";
10command.ExecuteNonQuery();
11
12}
You need to log error information if the transaction fails to commit or roll back.
Which code segment should you insert at line 11?

A) sqlTran.Commit(); } catch (Exception ex) { Trace.WriteLine(ex.Message); try { sqlTran.Rollback(); } catch (Exception exRollback) { Trace.WriteLine(exRollback.Message); } } }
B) catch (Exception ex){ Trace.WriteLine(ex.Message); try{ sqlTran.Rollback(); } catch (Exception exRollback){ Trace.WriteLine(exRollback.Message); }} finaly { sqltran.commit( );}}
C) sqlTran.Commit(); } catch (Exception ex) { sqlTran.Rollback(); Trace.WriteLine(ex.Message); }
D) catch (Exception ex) { sqlTran.Rollback(); Trace.WriteLine(ex.Message); } finaly { try { sqltran.commit( ); } catch (Exception exRollback) { Trace.WriteLine(excommit.Message); }}

2. You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application connects to a Microsoft SQL Server 2008 database. The application uses DataContexts to query the database. You create a function that meets the following requirements: "Updates the Customer table on the database when a customer is marked as deleted. "Updates the related entries in other tables (CustomerAddress, CustomerContacts) by marking them as deleted. "Prevents consumer code from setting the Deleted column's value directly. You need to ensure that the function verifies that customers have no outstanding orders before they are marked as deleted. You also need to ensure that existing applications can use the update function without requiring changes in the code. What should you do?

A) Override the Delete operation of the DataContext object.
B) Add new entities to the DataContext object for the Customers and Orders tables.
C) Override the Update operation of the DataContext object.
D) Modify the SELECT SQL statement provided to the DataContext object to use an INNER JOIN between the Customer and Orders tables.

3. You are implementing an ASP.NET Web site. The site contains the following class.
public class Address
{
public int AddressType;
public string Line1;
public string Line2;
public string City;
public string ZipPostalCode;
}
The Web site interacts with an external data service that requires Address instances to be given in the
following XML format.
<Address AddressType="2">
<Line1>250 Race Court</Line1>
<City>Chicago</City>
<PostalCode>60603</PostalCode>
</Address>
You need to ensure that Address instances that are serialized by the XmlSerializer class meet the XML
format requirements of the external data service.
Which two actions should you perform (Each correct answer presents part of the solution. Choose two.)

A) Add the following attribute to the Line2 field. [XmlElement(IsNullable=true)]
B) Add the following attribute to the AddressType field. [XmlAttribute]
C) Add the following attribute to the ZipPostalCode field. [XmlElement("PostalCode")]
D) Add the following attribute to the ZipPostalCode field. [XmlAttribute("ZipCode")]

4. A WCF service code is implemented as follows. (Line numbers are included for reference only.)
For interactive and self-paced preparation of exam 70-513, try our practice exams.
Practice exams also include self assessment and reporting features!
01 <ServiceContract()>
02 <ServiceBehavior(
03InstanceContextMode:=InstanceContextMode.Single)>
04Public Class CalculatorService
05
06 <OperationContract()>
07Public Function Calculate(ByVal op1 As Double,
08ByVal op As String, ByVal op2 As Double) As Double
...
24End Function
25
26End Class
You need to increase the rate by which clients get the required response from the service.
What are two possible ways to achieve this goal? (Each correct answer presents a complete solution.
Choose two.)

A) Change the service behavior to the following. <ServiceBehavior( InstanceContextMode:=InstanceContextMode.Single, ConcurrencyMode:=ConcurrencyMode.Multiple)>
B) Require the clients to use async operations when calling the service.
C) Require the clients use threads, the Parallel Task Library, or other mechanism to issue service calls in parallel.
D) Change the service behavior to the following. <ServiceBehavior(InstanceContextMode:=InstanceContextMode.PerCall)>

5. You need to design a solution for capturing an exception. Which approach should you recommend?

A) Use a Page_Error method.
B) Use a customErrors element.
C) Use an Application_Error method.
D) Use a HandleError attribute.

Solutions: