You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The
application connects to a Microsoft SQL Server database. The application has two DataTable objects that
reference the Customers and Orders tables in the database. The application contains the following code
segment. (Line numbers are included for reference only.
01DataSet customerOrders = new DataSet();
02customerOrders.EnforceConstraints = true;
03ForeignKeyConstraint ordersFK = new ForeignKeyConstraint("ordersFK",
04customerOrders.Tables["Customers"].Columns["CustomerID"],
05customerOrders.Tables["Orders"].Columns["CustomerID"]);
06
07customerOrders.Tables["Orders"].Constraints.Add(ordersFK);
You need to ensure that an exception is thrown when you attempt to delete Customer records that have
related Order records. Which code segment should you insert at line 06?

• A. ordersFK.DeleteRule = Rule.SetDefault;
• B. ordersFK.DeleteRule = Rule.SetNull;
• C. ordersFK.DeleteRule = Rule.None;
• D. ordersFK.DeleteRule = Rule.Cascade;

You are implementing an ASP.NET AJAX page. You add two UpdatePanel controls named pnlA and pnlB.
pnlA contains an UpdatePanel control named pnlAInner in its content template.
You have the following requirements.
?Update panels pnlA and pnlB must refresh their content only when controls that they contain cause a
postback.
?Update panel pnlAInner must refresh its content when controls in either pnlA or pnlB or pnlAInner cause a
postback.
You need to configure the panels to meet the requirements.
What should you do?

• A. Set the UpdateMode of pnlA and pnlB to Conditional. Set the UpdateMode of pnlAInner to Conditional, and add AsyncPostBackTrigger elements to its Triggers element for every control in pnlA.
• B. Set the UpdateMode of pnlA and pnlB to Conditional. Set the UpdateMode of pnlAInner to Always.
• C. Set the UpdateMode of pnlA and pnlB to Always. Set the UpdateMode of pnlAInner to Conditional.
• D. Set the UpdateMode of pnlA and pnlB to Always. Set the UpdateMode of pnlAInner to Always, and add AsyncPostBackTrigger elements to its Triggers element for every control in pnlB.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The
application connects to a Microsoft SQL Server database. The application uses a DataTable named
OrderDetailTable that has the following columns: "ID "OrderID "ProductID "Quantity "LineTotal Some
records contain a null value in the LineTotal field and 0 in the Quantity field. You write the following code
segment. (Line numbers are included for reference only.)
01DataColumn column = new DataColumn("UnitPrice", typeof(double));
02
03OrderDetailTable.Columns.Add(column);
You need to add a calculated DataColumn named UnitPrice to the OrderDetailTable object. You also need
to ensure that UnitPrice is set to 0 when it cannot be calculated. Which code segment should you insert at
line 02?

• A. column.Expression = "iif(Quantity > 0, LineTotal/Quantity, 0)";
• B. column.Expression = "LineTotal/ISNULL(Quantity, 1)";
• C. column.Expression = "if(Quantity > 0, LineTotal/Quantity, 0)";
• D. column.Expression = "LineTotal/Quantity";

You are creating a Windows Communication Foundation (WCF) service that is implemented as follows.
(Line numbers are included for reference only.)
01 [ServiceContract]
02 [ServiceBehavior(IncludeExceptionDetailsInFaults = true)]
03 public class OrderService
04 {
05 [OperationContract]
06 public void SubmitOrder(Order anOrder)
07 {
08 try
09 {
10 ...
11 }
12 catch(DivideByZeroException ex)
13 {
14
15 }
16 }
17 }
You need to ensure that the stack trace details of the exception are not included in the error information
sent to the client.
What should you do?

• A. Replace line 14 with the following line. throw;
• B. After line 05, add the following line. [FaultContract(typeof(FaultException<Order>))] Replace line 14 with the following line. throw ex;
• C. Replace line 14 with the following line.
  throw new FaultException<Order>(anOrder, ex.ToString());
• D. After line 05, add the following line. [FaultContract(typeof(FaultException<Order>))] Replace line 14 with the following line. throw new FaultException<Order>(anOrder, "Divide by zero exception");

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 database includes a database table named ProductCatalog as shown in the exhibit. (Click the Exhibit
button.)
You add the following code segment to query the first row of the ProductCatalog table. (Line numbers are
included for reference only.)
01 using (var 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 var id = reader.GetInt32(0);
10
11 reader.Close();
12 }
13 }
You need to read the values for the Weight, Price, and Status columns.
Which code segment should you insert at line 10?
Exhibit:

• A. var weight = reader.GetDecimal(1); var price = reader.GetFloat(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.GetDouble(2); var status = reader.GetByte(3);
• D. var weight = reader.GetDouble(1); var price = reader.GetDecimal(2); var status = reader.GetBoolean(3);