You create an application by using the Microsoft .NET Framework 3.5 and Microsoft
ADO.NET.The application contains a DataSet object that has a table. The DataSet object is
as shown in the following exhibit.
You need to ensure that the application meets the following requirements without creating another table:
The DataSet can be extended by using the designer.
The application displays all product records.
The product records can be filtered by ProductID.
What should you do?

You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5. The application includes a component. The component will be referenced by the .NET and COM applications.

The component contains the following code segment.
public class Employee
{
public Employee(string name)
{}
}

The .NET and COM applications must perform the following tasks:

Create objects of the Employee type.
Use these objects to access the employee details.

You need to ensure that the .NET and COM applications can consume the managed component.
What should you do?

You create a Microsoft ASP.NET application by using the Microsoft .NET Framework
version 3.5.You create a custom-templated server control.You need to ensure that the child
controls of the server control are uniquely identified within the control hierarchy of the page.
Which interface should you implement?

You are creating a distributed application by using Microsoft .NET Framework 3.5. The application uses the Windows Communication Foundation model.
You need to ensure that the following requirements are met:

User authentication is performed at the message level.
Data protection is performed at the transport level.
Server authentication is performed at the transport level.

What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

You create an application by using the Microsoft .NET Framework 3.5 and Microsoft
ADO.NET.The application contains a DataSet class. The DataSet class contains two tables
named Order and OrderDetail as shown in the following exhibit.OrderDetail as shown in the
following exhibit.
You add a DataColumn class named OrderTotal to the Order table.You need to ensure that
the OrderTotal column stores the sum of the values in the LineTotal column of the
OrderDetail table.Which expression string should you use to set the Expression property of
the OrderTotal column?

You are creating a Windows Communication Foundation service by using Microsoft .NET Framework 3.5. The client applications are unable to use SSL. You need to ensure that clients authenticate by using a token provided by a Security Token Service (STS). 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. The
application contains the following objects:
A SqlDataReader object named reader
A SqlCommand object named cmdRecords
A SqlCommand object named cmdUpdate
A SqlConnection object named conn
The SqlConnection object has the following ConnectionString property.”Server=Prod;
Database=Wingtip; Integrated Security=SSPI”
The reader object is obtained from the cmdRecords object. The conn object is shared by the
cmdRecords and the cmdUpdate objects.You need to ensure that for each record in the
reader object, the application calls the ExecuteNonQuery method of the cmdUpdate object.
What should you do?