You create an application by using the Microsoft .NET Framework 3.5 and Microsoft
ADO.NET. The application uses Microsoft SQL Server 2005.You write the following code
segment. (Line numbers are included for reference only.)
01 String myConnString = “User
02 ID=<username>;password=<strong password>;Initial
03 Catalog=pubs;Data Source=myServer”;
04 SqlConnection myConnection = new
05 SqlConnection(myConnString);
06 SqlCommand myCommand = new SqlCommand();
07 DbDataReader myReader;
08 myCommand.CommandType =
09 CommandType.Text;
10 myCommand.Connection = myConnection;
11 myCommand.CommandText = “Select * from Table1; Select * from Table2;”;
12 int RecordCount = 0;
13 try
14 {
15 myConnection.Open();
16
17 }
18 catch (Exception ex)
19 {
20 }
21 finally
22 {
23 myConnection.Close();
24 }
You need to compute the total number of records processed by the Select queries in the
RecordCount variable.Which code segment should you insert at line 16?

You create a Windows Communication Foundation (WCF) application by using Microsoft Visual Studio 2008 and the .NET Framework 3.5. You create a WCF service by using the following code segment. (Line numbers are included for reference only.)

01 [ServiceContract]
02 public interface IContosoService
03 {
04 [OperationContract]
06 void ProcessTransaction();
07 }
09 public class ContosoService : IContosoService
10 {
11 public void ProcessTransaction() {
12 try {
13 BusinessComponent.ProcessTransaction();
14 }
15 catch (ApplicationException appEx) {
17 }
18 }
19 }

The BusinessComponent.ProcessTransaction method will only throw exceptions from the ApplicationException type. You plan to debug the WCF service. You need to ensure that the WCF service meets the following requirements:

Detailed exception information is provided to the client application. Subsequent calls can be issued to the service by using the same proxy intance after an exception is caught in the client application. What should you do?

You are creating a Windows Forms application by using the .NET Framework 3.5. You write
a code segment to connect to a Microsoft Access database and populate a DataSet.You need
to ensure that the application meets the following requirements:
It displays all database exceptions.
It logs all other exceptions by using the LogExceptionToFile.
Which code segment should you use?

You are creating a Windows Communication Foundation service by using Microsoft .NET Framework 3.5. You create the following service contract. (Line numbers are included for reference only.)

01 [ServiceContract]
02 public interface IMyService
03 {
04 [OperationContract]
06 List<string> GetData(int index);
07 }

You need to ensure that the GetData operation can be accessed by using the URI in the following manner:

GetData/1 for the index value 1
GetData/2 for the index value 2
..
GetData/n for the index value n

Which code segment should you insert at line 05?

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?