You create an application by using the Microsoft .NET Framework 3.5 and Microsoft
ADO.NET. The application connects to a Microsoft SQL Server 2005 database. You write
the following code segment.
string query = “Select EmpNo, EmpName from dbo.Table_1;
select Name,Age from dbo.Table_2″;
SqlCommand command = new SqlCommand(query, connection);
SqlDataReader reader = command.ExecuteReader();
You need to ensure that the application reads all the rows returned by the code
segment.Which code segment should you use?

You are creating a Windows Communication Foundation (WCF) service by using Microsoft .NET Framework 3.5. The WCF service will validate certificates to authorize client applications. You write the following code segment.

class Store: IStore
{
public void RemoveOrder(int ordered)
{}
}

You need to ensure that only those client applications that meet the following criteria can access the RemoveOrder method:

“AdminUser” is the subject in the client certificate. “1bf47e90f00acf4c0089cda65e0aadcf1cedd592” is the thumbprint in the client certificate.

What should you do?

You create an application by using the Microsoft .NET Framework 3.5 and Microsoft
ADO.NET. The application connects to a Microsoft SQL Server 2005 database.You write
the following code segment. (Line numbers are included for reference only.)
01 using (SqlConnection connection = new SqlConnection(connectionString)) {
02 SqlCommand cmd = new SqlCommand(queryString, connection);
03 connection.Open();
04
05 while (sdrdr.Read()){
06 // use the data in the reader
07 }
08 }
You need to ensure that the memory is used efficiently when retrieving BLOBs from the
database.Which code segment should you insert at line 04?

You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5. The application will be used by multiple types of users. The application will also interact with external applications. You need to design the interaction among the application, the users of the application, and the external applications. What should you do?