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 create Microsoft Windows-based applications. You create a banking application that will be used by the account managers of the bank.

You identify a method to simulate the deposit functionality of a savings account. The method will calculate the final balance when monthly deposit, number of months, and quarterly rate are given. The application requirements state that the following criteria must be used to calculate the balance amount:

Apply the quarterly interest rate to the balance amount of the account every three months. Apply the quarterly interest rate before the monthly deposit is calculated for the third month.

You translate the outlined specification into pseudo code. You write the following lines of code. (Line numbers are included for reference only.)

Method

public static decimal SimulateSavings

Input parameters
int months
decimal monthlyPayment
decimal quarterlyRate

Pseudo code

01 Declare balance variable, initialize it to zero
03 Return balance

You need to insert the appropriate code in line 02. Which code segment should you insert?

You create Microsoft Windows-based applications. You are creating a mathematics educational application. The application will be used to teach students about numeric series. One of the methods in the application is used to calculate a given member of the Fibonacci series. The method uses recursive calls to perform its calculation. The application calls the method synchronously, and only one instance of the application can be running at a given time. The application requirements state that the method must take less than 5 seconds to process when calculating any of the first 30 members of the Fibonacci series. You profile the application by using instrumentation. During profiling, you perform a call on the method that is used for calculating the 30th member of the Fibonacci series. The profiling report, which shows elapsed time in milliseconds, is shown in the exhibit. (Click the Exhibit button.) You need to evaluate the performance of the application based on the established requirements.
What should you conclude?

You create Microsoft Windows-based applications. You are responsible for evaluating the deployment of a product-pricing application. This application will be deployed on portable computers that are used by a team of sales personnel.

The application must meet the following requirements:

The application must run successfully on a dial-up connection.
Users need to run the application locally.
New features are added to the application on a monthly basis.

You need to provide a deployment solution that will ensure your users always have the latest version of the application when they connect to the corporate network. What should you recommend?

You create Microsoft Windows-based applications. You are creating a method. Your applications will call the method multiple times. You write the following lines of code for the method.

public string BuildSQL(string strFields, string strTable, string strFilterId) {
string sqlInstruction = “SELECT “;
sqlInstruction += strFields;
sqlInstruction += ” FROM “;
sqlInstruction += strTable;
sqlInstruction += ” WHERE id =”;
sqlInstruction += strFilterid;
return sqlInstruction;
}

The method generates performance issues. You need to minimize the performance issues that the multiple string concatenations generate.
What should you do?

You create Microsoft Windows-based applications. You are upgrading an application that contains custom data-centric user controls. Each of these controls implements its own custom data-binding logic. Much of the data-binding code is similar from control to control. You create a new component that combines the common data-binding logic. You change the existing controls so they use this new component. You need to decide which tier of the application architecture this component will belong to. Where should you place the component?

You are creating a Windows Forms application that includes the database
helper methods UpdateOrder and UpdateAccount. Each method wraps code that connects to a Microsoft SQL Server 2005 database, executes a Transact-SQL statement, and then disconnects from the database. You must ensure that changes to the database that result from the UpdateAccount method are committed only if the UpdateOrder method succeeds. You need to execute the UpdateAccount method and the UpdateOrder method.
Which code segment should you use?

You are creating a Windows Forms application. The application loads a data table named dt from a database and modifies each value in the data table. You add the following code.
(Line numbers are included for reference only.)

01 foreach (DataRow row in dt.Rows) {
02 foreach (DataColumn col in dt.Columns) {
04 Trace.WriteLine(str);
05 }
06 }

You need to format the string named str to show the value of the column at the time the data is loaded and the current value in the column.
Which code segment should you add at line 03?

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?

You create Microsoft Windows-based applications. You are upgrading an application that contains custom data-centric user controls. Each of these controls implements its own custom data-binding logic. Much of the data-binding code is similar from control to control. You create a new component that combines the common data-binding logic. You change the existing controls so they use this new component. You need to decide which tier of the application architecture this component will belong to. Where should you place the component?