Microsoft 70-523 : UPG:Transition MCPD.NET Frmwrk 3.5 Web Dev to 4 Web Dev

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. catch (Exception ex){ Trace.WriteLine(ex.Message); try{ sqlTran.Rollback(); } catch (Exception exRollback){ Trace.WriteLine(exRollback.Message); }} finaly { sqltran.commit( );}}
• B. catch (Exception ex) { sqlTran.Rollback(); Trace.WriteLine(ex.Message); } finaly { try { sqltran.commit( ); } catch (Exception exRollback) { Trace.WriteLine(excommit.Message); }}
• C. sqlTran.Commit(); } catch (Exception ex) { sqlTran.Rollback(); Trace.WriteLine(ex.Message); }
• D. sqlTran.Commit(); } catch (Exception ex) { Trace.WriteLine(ex.Message); try {
  sqlTran.Rollback();
  }
  catch (Exception exRollback) {
  Trace.WriteLine(exRollback.Message);
  } } }

You are implementing an ASP.NET Web page.
You need to add a text box that allows only values between 1 and 10, inclusive, to be submitted. Which two
code segments should you use? (Each correct answer presents part of the solution. Choose two.)

• A. <asp:TextBox ID="txt1" runat="server" /> <asp:CustomValidator ID="val1" runat="server" ControlToValidate="txt1" ClientValidationFunction="validate_value" ErrorMessage="Value invalid" />
• B. <asp:TextBox ID="txt1" runat="server" onChange="validate_value(this, args)" />
• C. <script type="text/javascript"> function validate_value(obj, args) { args.IsValid = (args.Value >= 1 && args.Value <= 10); } </script>
• D. <script type="text/javascript"> function validate_value(obj, args) { return (args.Value >= 1 && args.Value <= 10); } </script>

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You use
the ADO.NET Entity Framework to model your entities.
You use Plain Old CLR Objects (POCO) entities along with snapshot-based change tracking. The code
accesses the POCO entities directly.
You need to ensure that the state manager synchronizes when changes are made to the object graph.
Which ObjectContext method should you call?

• A. SaveChanges
• B. Refresh
• C. DetectChanges
• D. ApplyPropertyChanges

You are implementing an ASP.NET page in an e-commerce application. Code in a btnAddToCart_Click
event handler adds a product to the shopping cart.
The page should check the status of the shopping cart and always show a cart icon when one or more
items are in the shopping cart. The page should hide the icon when the shopping cart has no items. You
need to add an event handler to implement this requirement.
Which event handler should you add?

• A. Page_PreRender
• B. Page_PreInit
• C. Page_Load
• D. btnAddToCart_Click

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 updated function without requiring changes in the code. What should you do?

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