You use Microsoft .NET Framework 4 to develop an application that connects to a Microsoft SQL
Server 2008 database. You add the following stored procedure to the database.
CREATE PROCEDURE GetSalesPeople
AS
BEGIN
SELECT FirstName, LastName, Suffix, Email, Phone
FROM SalesPeople
END
You write the following code. (Line numbers are included for reference only.)
01 Dim connection As SqlConnection = New SqlConnection(“& “)
02 Dim command As SqlCommand = New SqlCommand(“GetSalesPeople”, connection)

03 command.CommandType = CommandType.StoredProcedure
04
You need to retrieve all of the results from the stored procedure. Which code segment should you
insert at line 04

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 the following object
query to load a product from the database. (Line numbers are included for reference only.)
01 Using advWorksContext As New AdventureWorksEntities()
02 Dim productQuery As ObjectQuery(Of Product) =
03 advWorksContext.Product.Where(“it.ProductID = 900”)
04
05 End Using
You need to log the command that the query executes against the data source. Which code segment
should you insert at line 04?

You use Microsoft Visual Studio 2010 and Microsoft NET Framework 4 to create an application. You
deploy a Windows Communication Foundation (WCF) Data Service to a production server. The
application is hosted by Internet Information Services (US). After deployment applications that
connect to the service receive the following error message. The server encountered an error
processing the request. See server logs for more details. You need to ensure that the actual
exception data is provided to client computers. What should you do?

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an app1ication. 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)
01 Using connection As New SqlConnection(cnnStr)
02 connnectionOpen()
03 Dim sqlTran As SqlTransaction = connection.BeginTraraction()
04 Din command As Sqlcommand = connection Createcommand()
05 commandTransation = sqlTran
06 Try
07 command.CommandText = “INSERT INTO Production.ScrapReason(Name)
VALUES(‘Wrong size’)”
08 command.ExecuteNonQuery()
09 command.CommandText = “INSERT INTO Production ScrapReason(Name)
VALIES(’Wrong color’)”
10 command.ExecuteNonQuery()
11
12 End Using
You need to log error information if the transaction fails to commit or roll back. Which code segment
should you insert line 11?