A Windows Forms application contains the following code segment.

string SQL = @”SELECT OrderID, ProductID, UnitPrice, Quantity FROM [Order Details]”;
SqlDataAdapter da = new SqlDataAdapter(SQL, connStr);
DataTable dt = new DataTable();
da.Fill(dt);

You need to add a new column to the data table named ItemSubtotal. The ItemSubtotal column must contain the value of the UnitPrice column multiplied by the value of the Quantity column.
Which code segment should you use?

You create Microsoft Windows-based applications. You are creating a component that will encapsulate a data source. Dozens of applications will use the component.

The component must meet the following design requirements:

1.The component must be able to be modified within a Rapid Application Development environment.
2.The component must be without a user interface.

You propose to derive the component from the System.Windows.Forms.Control class and to implement the IComponent interface. You need to decide whether the component will meet the requirements.
What should you conclude?

You create Microsoft Windows-based applications. You need to evaluate the design concept of an application.

The application must meet the following requirements:

The application relies on the operating system for authentication. The application minimizes the amount of data sent over the network when connecting to the database. The application exposes data access code so that the future Web-based and mobile applications can reuse them.
The application permits users to view and edit data contained in tables from a Microsoft SQL Server 2005 database.
The application controls access to the SQL Server 2005 database at the table level.

The design contains the following elements:

The SQL Server 2005 database uses the Windows Authentication mode. A database schema that grants rights to the users at the table level. A stored procedure in Transact-SQL that accesses the necessary data required by the application. A Web service that uses a pre-defined credential to access the database and run the stored procedures. A Microsoft Windows-based application that impersonates the logged-on user and calls the Web service to retrieve and update the data.
You need to evaluate the design and recommend appropriately.
What should you recommend?

You are creating a class that uses unmanaged resources. This class maintains references to managed resources on other objects. You need to ensure that users of this class can explicitly release resources when the class instance ceases to be needed.
Which three actions should you perform? (Each correct answer presents part of the solution. Choose three.)

You need to create a method to clear a Queue named q.
Which code segment should you use?

You create a class library that contains the class hierarchy defined in the following code segment. (Line numbers are included for reference only.)

01 public class Group {
02 public Employee[] Employees;
03 }
04 public class Employee {
05 public string Name;
06 }
07 public class Manager : Employee {
08 public int Level;
09 }

You create an instance of the Group class. You populate the fields of the instance. When you attempt to serialize the instance by using the Serialize method of the XmlSerializer class, you receive InvalidOperationException. You also receive the following error message: “There was an error generating the XML document.” You need to modify the code segment so that you can successfully serialize instances of the Group class by using the XmlSerializer class. You also need to ensure that the XML output contains an element for all public fields in the class hierarchy.
What should you do?

You are creating an assembly named Assembly1. Assembly1 contains a public method. The global cache contains a second assembly named Assembly2. You must ensure that the public method is only called from Assembly2.
Which permission class should you use?

You create Microsoft Windows-based applications. You create an application that loads bulk weather data into a data warehouse for analysis. The application is used by data-entry technicians. One data-entry technician is visually impaired. The data-entry technicians provide a large flat file as the source of the data, and they typically minimize the application so that they can use other programs while the data is being loaded. The data entry technicians must load as many data files as possible during the course of their work day. The user interface contains a progress bar control that has a text label. The text label indicates the current percentage of progress. You need to provide appropriate status feedback to the user by indicating that the process is complete.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You create Microsoft Windows-based applications. You are developing an application that will be used by stock traders. The project scope contains the following requirements:

The application must permit users to set thresholds for minimum and maximum values for different stocks.
The application must alert the user when stock prices reach the pre-defined thresholds.
The application must permit the user to either buy or sell stock and specify the quantity of stock to trade.
The application must permit multiple alerts to be displayed simultaneously.

You need to decide how to implement the alert mechanism.
What should you do?

You create Microsoft Windows-based applications. You participate in the planning phase of an incident tracking tool for technical support analysts.

The incident tracking tool must meet the following requirements:

Technical support analysts must open multiple incidents simultaneously.
The application can run only one instance at a time.
Users must be able to adjust the order and layout of the incident screens.

You need to design an application user interface that meets these requirements with the minimum amount of code.
Which action should you perform?