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 are creating a Windows Communication Foundation service by using Microsoft .NET Framework 3.5. You write the following code segment. (Line numbers are included for reference only.)

01 [ServiceContract(Namespace=”http://uri.contoso.com”)] 02 public interface IMyService
03 {
04 [OperationContract]
05 string ProcessDetails(string s);

06 [OperationContract(Action=”UpdateStatus”)]
07 void UpdateStatus();
09 }

If the existing operation contract is unable to process a request made to the service, a generic operation contract must attempt to process the request. You need to create the generic operation contract. Which code segment should you insert at line 08?

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.The
application analyzes large amounts of transaction data that are stored in a different database.
You write the following code segment. (Line numbers are included for reference only.)
01 using (SqlConnection connection = new SqlConnection(sourceConnectionString))
02 using (SqlConnection connection2 = new SqlConnection(destinationConnectionString))
03 using (SqlCommand command = new SqlCommand())
04 {
05 connection.Open();
06 connection2.Open();
07 using (SqlDataReader reader = command.ExecuteReader())
08 {
09 using (SqlBulkCopy bulkCopy = new
SqlBulkCopy(connection2))
10 {
11
12 }
13 }
14 }
You need to copy the transaction data to the database of the application. Which code
segment should you insert at line 11?

You are creating a distributed application by using Microsoft .NET Framework 3.5. You use Windows Communication Foundation to create the application. You plan to perform the following tasks:

Authenticate the client applications by using Microsoft ASP.NET membership provider. Authorize the client applications by using Microsoft ASP.NET role provider. You write the following code segment.

[ServiceContract]
public interface IService
{
[OperationContract]
void Remove(int id);
}
public class Service : IService
{
public void Remove(int id)
{}
}

You need to ensure that only those client applications that provide credentials belonging to the AdminGroup role can access the Remove method. What should you do?